Pages

Saturday, September 21, 2013

SQL SERVER – Simple Example of Cursor | Journey to SQL Authority with Pinal Dave

UPDATE: For working example using AdventureWorks visit : SQL SERVER - Simple Example of Cursor - Sample Cursor Part 2 This is the simplest example of the SQL Server Cursor. I have used this all the time for any use of Cursor in my T-SQL. DECLARE @AccountID INT DECLARE @getAccountID CURSOR SET @getAccountID = CURSOR FOR SELECT… Continue Reading...

Source: SQL SERVER – Simple Example of Cursor | Journey to SQL Authority with Pinal Dave