| SQL Server stored procedures tutorial: Write, tune and get examples: Learn how to write and tune SQL Server stored procedures in this tutorial. Also included is a collection of stored procedure examples for you to browse. |
| Find size of SQL Server tables and other objects with stored procedure: Check the size of SQL Server tables and other database objects with an original stored procedure, sp_SOS, that expands on sp_spaceused. Calculate space and perform more functions. |
| Stored procedure to find fragmented indexes in SQL Server: Here's a stored procedure to find fragmented indexes on all servers and databases in SQL Server environments and improve application performance. |
| Examples of SQL Server stored procedures and parameters: Find examples of SQL Server stored procedures and parameters not documented by Microsoft. |
| FAQ: SQL Server stored procedure how-tos: Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines. |
| Stored procedure: A simple way to perform crosstab operations: SQL Server crosstab operations usually involve complicated T-SQL coding. This tip explains how the process is made simple with the sp_Crosstab stored procedure. |
| Stored procedure to monitor long-running jobs in SQL Server 2000: Get a stored procedure to monitor long-running jobs in SQL Server 2000. This T-SQL stored procedure (SP) also provides email alerts about jobs that decrease SQL Server performance. |
| Stored procedure: Execute T-SQL code from a file: Existing routines to execute T-SQL code from a file without using osql and xp_cmdshell, have many limitations. The sp_ExecuteSQLFromFile stored procedure addresses the shortcomings |
| CLR stored procedures versus T-SQL stored procedures: How do CLR stored procedures and functions perform compared to T-SQL stored procedures and functions? |
| 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. |
| Stored procedures: Find columns and tables: Continuing our stored procedure series, this simple routine is handy for finding columns by name and listing the table(s) in which they exist. |
| Top 10 SQL Server development tips of 2008: From converting date/time values into character types to retrieving XML data values with XQuery, these were the top 10 SQL Server development topics of 2008. |
| SQL Server and data manipulation in T-SQL: Learn about stored procedures, parameters, triggers and other T-SQL code functions in this book excerpt. |
| SQL Server stored procedures tutorial: Write, tune and get examples: Learn how to write and tune SQL Server stored procedures in this tutorial. Also included is a collection of stored procedure examples for you to browse. |
| Top 10 SQL Server development questions: SQL Server development can put you in a crunch. Get solutions here when it comes to concurrency problems, stored procedure results and writing T-SQL. |
| FAQ: SQL Server stored procedure how-tos: Write and run SQL Server stored procedures more effectively. This collection of FAQs will start you on the path to working with useful T-SQL routines. |
Show me everything on 
- A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm.
In a database, a trigger is a set of Structured Query Language
(
