Manage

SQL Transact SQL T SQL

• Where to start debugging the stored procedure

  Learn how to prepare to debug a stored procedure from Visual Studio 2005. Continue Reading

• Sample T-SQL stored procedure: P_DisplayProductDetails

  This sample T-SQL stored procedure to be debugged displays product details from the AdventureWorks database using a function to rank the unit price for each product subcategory. Continue Reading

• How to run the stored procedure

  By stepping into a stored procedure, you are essentially telling Visual Studio to start running the procedure line by line. Continue Reading

• Working with typed DataReader and SqlResultSet data

  Get code samples to extract column values to native .NET data types. Continue Reading

• Top five T-SQL stored procedures

  From finding columns and tables to executing code from a file, Brian Walker's top five stored procedures will offer the simple tricks you need to get routine tasks done. Continue Reading

• T-SQL code to create stored procedures

  Contributor Brian Walker provides the code you need to create six system stored procedures to support a surrogate key architecture.Continue Reading

• Utilities to maintain a surrogate key architecture

  You've discovered why and when to work with a surrogate key architecture, and how to establish its framework. In the third installment of this series, learn how to maintain the database with utility routines and stored procedures.Continue Reading

• Columns and objects to support a surrogate key architecture

  Ask a group of database administrators if they prefer surrogate keys over natural data keys to implement relationships between tables, and chances are you'll get some very different opinions. In the second part of this special feature, contributor ...Continue Reading

• A surrogate key architecture to perform powerful SQL Server database operations

  A surrogate key architecture enables you to have generic administrative routines that can perform many powerful operations on the database schema or the data itself. This technical advice feature describes a suggested surrogate key architecture and ...Continue Reading