Some useful undocumented extended and stored procedures in SQL Server 2005  Read more...

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...

Building an application with modular programming not only speeds development, but can make for a more stable application. New author Sreeju Jumar brings us a look at how you can further modularize your stored procedures.  Read more...

QL 2005 adds two new methods – signing with certificates and impersonation with EXECUTE AS – that can manage cases where the classic method of ownership chaining fails. I explain the two new methods, as well as the old one, and warns you about the pitfalls.  Read more...

Different ways of passing sets of data between stored procedures.  Read more...

A view to examine the parameters in use by procedures, functions, etc.  Read more...

Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.  Read more...

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...

Regular columnist Robert Marda writes about the basics of using output parameters. If you're not using output params we hope this article will get you started - they are a great way to return less data to the client, perfect if you need only a few values and not a recordset/resultset.   Read more...

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...

We're pleased to announce that Robert will be writing for us each month - generally on stored procedures, but occasionally on a different topic. This article discusses how nesting stored procedures works and how to use @@NextLevel. Good reading! If there is a stored procedure topic you'd like to see covered, add a comment to the article or email us at articles@sqlservercentral.com   Read more...

In the fourth installment of this series, Jacob Sebastian moves on to SQL Server 2005 and the new XML capabilities that make working with XML data easier than ever.   Read more...

In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes.   Read more...

In the first part of this series, Jacob Sebastion showed us how to use XML to save a sales order to the database with a variable amount of line items. In part 2, he continues looking at XML in SQL Server 2000 with some advanced XML processing.   Read more...

How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.   Read more...

Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities.  Read more...

The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters.   Read more...

Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.  Read more...

SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.   Read more...

Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.   Read more...

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...

Some useful undocumented extended and stored procedures in SQL Server 2005  Read more...

Different ways of passing sets of data between stored procedures.  Read more...