July 4, 2005 at 11:28 pm
Hello friends,
Please help me out
I am very new to sql server2000, can u please tell me with simple example how to create store procedure and cursers in that , please explain in details (Creating cursors,begins,declare,end , allocate,deallocate,raise error,fetch...like)
T.I.A
Shashank
Regards,
Papillon
July 4, 2005 at 11:57 pm
Hello Shashank, and welcome to the wonderful world that is SQL Server.
First of all, having someone explain basics here will not give you a good understanding. I suggest starting by reading what Books Online says. You could for instance start at the topics DECLARE CURSOR and CREATE PROCEDURE.
However, I have a question for you. Why do you think you need cursors? In SQL Server cursors are very seldomly used (or at least they should be). Almost everything you can do with a cursor can be replaced with a set-based query (or several) instead, which will perform magnitudes better.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply