Manage

SQL Transact SQL T SQL

• Top 10 T-SQL tips for improved SQL Server development

  Learn to script SQL Server backups, why T-SQL in SSIS has pros and cons and workarounds for T-SQL code causing SQL Server performance problems.Continue Reading

• Basic Transact-SQL programming constructs: 15 tips, 15 minutes

  The programming language used in Microsoft SQL Server is called Transact-SQL (T-SQL). It complies with the ANSI SQL-92 standard, and you can use this ANSI SQL-compliant language to select, update, insert and delete records from tables.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

• Visual Studio debug windows

  Visual Studio provides you with many informative debug windows, which you can review in this T-SQL stored procedure debugging feature.Continue Reading

• 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

• 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