Website Design United States, Website Design California, Website Designing United States, Website Designing California

Stored Procedure Using Cursor - SQL

Anonymous

Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time.

For example, you can use cursor to include a list of all user databases and make multiple operations against each database by passing each database name as a variable.

USE pubs
declare @Auth_Last as varchar(30)
DECLARE authors_cursor CURSOR FOR
SELECT au_lname FROM authors WHERE au_lname LIKE 'B%'
OPEN authors_cursor -- Perform the first fetch.
FETCH NEXT FROM authors_cursor into @Auth_Last
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN -- This is executed as long as the previous fetch succeeds.
SELECT @Auth_Last as Auth_Last
FETCH NEXT FROM authors_cursor into @Auth_Last
END
CLOSE authors_cursor
DEALLOCATE authors_cursor
GO

 















 


© 2008-2009 dotnet4all.com