|
Does anyone have a good resource and template on how to write an extended stored procedure for a SQL Server 2000 instance?
(comments are locked)
|
|
http://msdn.microsoft.com/en-us/library/aa197263(SQL.80).aspx But there is not much secret , and you need to know C/C++. You can use the gcc compiler (free) , it had the Windows development and is also free Dev-C++, donwload -> http://www.bloodshed.net/devcpp.html. build the DLL and use Caution: .nextval bumps the value If you want the current value without modifying it, use the .currval method.
Feb 02 '10 at 03:32 PM
KillerDBA
Nice catch Killer!
Feb 02 '10 at 05:02 PM
HillbillyToad
Thank you guys for providing your valuable answer to this..:)
Feb 03 '10 at 08:31 AM
OraLearner
However.....currval can only be used if you've already selected from that sequence in the CURRENT session. I will edit the initial response.
Feb 03 '10 at 03:49 PM
Dwayne King
Ah-hah. I didn't know that. Thanks.
Feb 03 '10 at 05:05 PM
KillerDBA
(comments are locked)
|
