Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. niceboykunal123

    helpt to fix the stored proc to count rows of tables in db

    Could you please help me to FIX the same, tried ifs & buts but No Luck....!
  2. niceboykunal123

    helpt to fix the stored proc to count rows of tables in db

    Hi, Yes I am trying to write stored proc, which counts the no. of rows present in the table and have the code as below:- CREATE PROCEDURE test_tableCount() LANGUAGE SQL BEGIN DECLARE SQLCODE INTEGER DEFAULT 0; DECLARE SQLSTATE CHAR(5); DECLARE vTableName VARCHAR(20); DECLARE...
  3. niceboykunal123

    helpt to fix the stored proc to count rows of tables in db

    CREATE PROCEDURE tableCount()LANGUAGE SQLBEGIN DECLARE SQLCODE INTEGER DEFAULT 0; DECLARE SQLSTATE CHAR(5); DECLARE vTableName VARCHAR(20); DECLARE vTableCount INTEGER; DECLARE stmt varchar(2000); DECLARE not_found CONDITION FOR SQLSTATE '02000'; DECLARE c1 CURSOR FOR SELECT...

Part and Inventory Search

Back
Top