|
Home > Archive > SQL server exams > March 2002 > study notes for Stored Procedures
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
study notes for Stored Procedures
|
|
| baruugh 2002-02-04, 2:05 pm |
| Hi,
I'm studying for 70-229. The books I have don't really give in-depth notes on writing your own Stored procedures, & I don't want to have to buy yet another book just for this info.
Does anyone have any URLs of good notes/tutorials for SPs?
Thanks | |
| msexpert 2002-02-04, 11:17 pm |
| SQL Books Online is an excellent resource. You will find everything you need there - for FREE. | |
|
|
| mrutgers 2002-03-02, 12:31 pm |
| You can also examine the source for the dozens of system stored procedures that are part of every SQL Server database. Although system sprocs address different needs than your average user sproc (they work with the system tables, something you should stee clear of in your own!), they still show you how to organise production-quality sprocs.
To see the source for a sproc, expand any database in Enterprise Manager, select Stored Procedures and double-click the procedure. Make sure to click Cancel to close the code window; DO NOT click OK - you dont want to accidentally change the code!. |
|
|
|
|
of this: