quote:

---

Originally posted by asm

Hi

I want to display/delete the tables record from the database
from single query or procedure. I am trying this procedure to
display the record but error message given.. pls help how to
do this..


CREATe PROCEDURE spTables
AS
DECLARE @TName varchar(100)
BEGIN
--Declare the Cursor
DECLARE C1 CURSOR FOR SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES WHERE Table_Type='BASE TABLE' ORDER BY Table_Name
--Open the Cursor
OPEN C1
--Fetch the Next Record from Table to Cursor
FETCH NEXT FROM C1 INTO @TName
--While Loop
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT 'Table Name : '+ @TName
exec('SELECT * FROM ' + @TName)
FETCH NEXT FROM C1 INTO @TName
END
CLOSE C1
DEALLOCATE C1
END
GO


Thanks

---