GitHub

cursor-status-transact-sql.md

For a given parameter, CURSOR_STATUS shows whether or not a cursor declaration has returned a cursor and result set. 1 The cursor result set has at least one row. For insensitive and keyset cursors, ...
GitHub

declare-cursor-transact-sql.md

Defines the attributes of a [!INCLUDE tsql] server cursor, such as its scrolling behavior and the query used to build the result set on which the cursor operates. DECLARE CURSOR accepts both a syntax ...
Ars Technica

T-SQL Populating local variables from cursor

Can anyone tell me why I receive this error msg when I run this code;<BR><BR>Error Msg: Server: Msg 16924, Level 16, State 1, Line 16<BR>Cursorfetch: The number of ...
Redmond Magazine

T-SQL Tips -- GO # and WHILE Loops

While there are a great many books, blogs, and articles out there on T-SQL, there are always a few little "tricks" that many people overlook, or that many authors assume readers know. So this week, ...
Ars Technica

TSQL: Need to multiply nearly all columns in nearly all tables by a number

We are dummying up some sample data for testing. I want to take any number that is NOT 100 and then multiple it by (for example) 0.8. I was thinking I could look at sys.objects and sys.columns to get ...