How to Share Data Between Stored Procedures
Different ways of passing sets of data between stored procedures.
2008-04-08
7,906 reads
Stored Procedures
2008-02-25 (first published: 2008-01-15)
921 reads
Passing a Table to A Stored Procedure
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.
2008-05-02 (first published: 2007-05-30)
69,263 reads
Sales Order Workshop Part IV
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.
2007-04-05
12,800 reads
SQL Server Error Handling Workbench
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.
2007-03-06
3,580 reads
Adding In HTML Links
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.
2006-08-08
6,314 reads
The Zero to N Parameter Problem
T-SQL has some well known limitations when working with parameters for a stored procedure, not the least of which is a variable number of parameters. While there are some solutions, they can be cumbersome to work with. Sloan Holliday brings us a creative solution using XML that can solve many issues.
2006-02-28
11,985 reads
Using Parameters with Stored Procedures
It seems that SQL Server developers avoid stored procedures whenever possible, especially if they are new to the product. Kathi Kellenberger brings us a basic article that you can give to developers that explains the basics of how you use parameters with ADO.NET, especially output parameters.
2019-05-23 (first published: 2005-08-08)
119,524 reads
Customized Output Labels
SQL Server has some great solutions for writing reports easily, ensuring quick service for your customers. However many of the quick ways of generating reports from the database include the column headers in the results. And often clients who expect customized work want to see labels that are more familiar to them. Leo Peysakhovich has developed a way that allows him to easily return custom labels from his stored procedures.
2004-10-14
5,797 reads
Capturing The Error Description In A Stored Procedure
Error handling is one of those things that is simple to do in SQL Server, but most people don't do it and it's not the most rebust thing. Here's another way that you can implement error handling in your stored procedures from a new author Amit Jethva.
2004-04-27
21,335 reads
Blogs
Migrate to Azure PostgreSQL Flexible Server
I need to migrate from a single server to a flex server. Instead of...
Using Copilot to help me update SQL Saturday
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
Master SQL with This Free Course (141 Interactive Exercises Included)
SQL is essential for modern businesses and applications that rely on data. It's a...
Forums
The Vast Expansions of Hardware
Comments posted to this topic are about the item The Vast Expansions of Hardware
Code Blocks
Comments posted to this topic are about the item Code Blocks
does netsuite really hide columns from customers?
Hi we built a gateway from sql server to netsuite using an oracle competitor's...
Question of the Day
Code Blocks
What happens with this code:
DECLARE @Iteration INT = 0;
WHILE @Iteration < 10
SELECT CustomerName,
CustomerStatus
FROM dbo.Customer
WHERE CustomerID > 3;
SET @Iteration += 1;
See possible answers