I am very comfortable creating fairly complex stored procedures in sql 2000 for reporting and jobs, but I have been mostly self-taught. Could anyone recommend a good stored procedure book that can help a person like me update their skills (I might be totally writing them wrong) as well as how to optimize them? We do not own any of the application code and can't really modify the existing tables and indexes so I'm looking for something solely focussed on the creation of the sp itself.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Anyone recommend a good sp book?
- Thread starter Luvsql
- Start date
The one and only The Guru's Guide to Transact-SQL
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQL Server Programming Hacks
- Status
Similar threads
- Locked
- Question