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!

Recent content by niceboykunal123

  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