CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
study notes for Stored Procedures
|
baruugh
Junior Member
Registered: Nov 2001
Location: Wellington
Country: New Zealand (Aotearoa)
State:
Certifications: MCP (70-228, 70-229)
Working on: MCDBA
Total Posts: 26
|
|
 study notes for Stored Procedures
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
Report this post to a moderator
|
|
 02-04-02 07:05 PM
|
|
msexpert
Member
Registered: Feb 2001
Location:
Country: Canada
State: ON
Certifications:
Working on: none
Total Posts: 43
|
|
|
|
02-05-02 04:17 AM
|
|
wbafrank
Moderator
M
Registered: Nov 2001
Location:
Country: Great Britain (UK)
State:
Certifications: MCP, MCSA, MCSE, MCSD, MCDBA, A+, CCNA, i-Net+, M CIW SD, CIW P, CIW Associate
Working on: CCNP (2/4)
Total Posts: 3787
|
|
|
|
02-10-02 08:00 PM
|
|
mrutgers
Junior Member
Registered: Mar 2002
Location:
Country: United Kingdom
State:
Certifications: MCSD, MCDBA
Working on:
Total Posts: 7
|
|
|
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!.
Report this post to a moderator
|
|
|
03-02-02 05:31 PM
|
|
|
MCSE exam notes
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is ON. |
|
ExamNotes forum archive
|
Have a read .........
of this: