Advanced Stored Procedures

[VBXL]

Does anybody know of a website which has examples of stored procedures.

Cheers

xplain

 

[tlbroadbent]

Many resources are listed in faq183-718 and faq183-694. Here are some that I use frequently.

Microsoft's MSDN and Technet sites.

SQL Magazine:

http://www.sqlmag.com/

SQL Server worldwide users' group:

http://www.sswug.org/

SQL Team:

http://www.sqlteam.com/

TeamDBA:

http://www.teamdba.com/

Umachandar Jayachandran provides a bunch of great T-SQL scripts on his web site. One can learn a lot by examining these scripts

SQL Server 6.x-7.0:

http://www.umachandar.com/technical/SQL6x70Scripts/Main.htm

SQL Server 7.0:

http://www.umachandar.com/technical/SQL70Scripts/Main.htm

SQL Server 2000:

http://www.umachandar.com/technical/SQL2000Scripts/Main.htm

In addition to great articles, Swynk.com maintains a library of SQL scripts. The scripts are categorized so you can quickly find what you are seeking - if it exists. The categories include; Maintenance and Management, Index Management, Replication, Data Warehouse, Lock and Connection Management, Miscellaneous, Mail, Backup / Restore, TSQL Aids, and SQL Server 6.x Scripts.

Swynk SQL script library:

http://www.swynk.com/sqlscripts/

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.