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...

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...

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...

Generic Script for Insert Update Stored Procedures  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 part 2 of this series, Jacob Sebastion 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...

While the strength of SQL Server is not in string manipulation, it can be very handy when backing a web site to be able to automatically include links for some of your content. New author Grey Wilson brings us an easy technique to easily deliver results to developers with URLs embedded inside.   Read more...

Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet!   Read more...