Alter proc to fetch a table structure from SQL Server 2005 database
hi please segest me… what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N’?') begin print N” print N’Usage: sp_table_struct @tablename, @flags int = 0′ print N’ where [...]

Answer Question   |  January 7, 2011  9:59 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables

How many rows will a FETCH statement return in an explicit cursor operation?
HOW many rows will a FETCH statement return in an explicit cursor operation?

Answer Question   |  December 28, 2009  3:15 AM
Cursor operation, Explicit cursors, FETCH statement