Brief contents: the SQL server 2005 environment and tools; stored procedure design concepts; basic transact-SQL programming constructs; functions; composite transact-SQL constructs: batches, scripts, and transactions; error handling; special types of stored procedures; views; triggers; user-defined functions; fundamentals of CLR stored procedure development; CRL functions and triggers; CRL database objects advanced topics; advanced stored procedure programming; debugging; source code management; database deployment; security; stored procedures for web search engines; interaction with the SQL server environment; Appendix: naming conventions stored procedure compilation, storage, and reuse; data types in SQL server 2005.