Stored Procedures

SQLServerCentral Article

Adding In HTML Links

  • Article

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.

You rated this post out of 5. Change rating

2006-08-08

6,263 reads

SQLServerCentral Article

The Zero to N Parameter Problem

  • Article

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.

4.5 (2)

You rated this post out of 5. Change rating

2006-02-28

11,969 reads

SQLServerCentral Article

Using Parameters with Stored Procedures

  • Article

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.

4.18 (28)

You rated this post out of 5. Change rating

2019-05-23 (first published: )

119,388 reads

SQLServerCentral Article

Customized Output Labels

  • Article

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.

You rated this post out of 5. Change rating

2004-10-14

5,796 reads

SQLServerCentral Article

Capturing The Error Description In A Stored Procedure

  • Article

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.

4.67 (3)

You rated this post out of 5. Change rating

2004-04-27

21,201 reads

SQLServerCentral Article

Output Parameters

  • Article

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.

2.37 (35)

You rated this post out of 5. Change rating

2007-10-26 (first published: )

32,529 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

By VAI

If anyone used artificial intel like Gee-Pee-Tee for writing T-SQL (MS SQL server) code...

Syntax Problem

By charliedurnin@gmail.com

I think that I am almost there but I am getting one red squiggle...

Excel Source [24]] Error: System.Exception: SqlTruncateException:

By yrstruly

Please assist. I am using SSIS to read data from an Excel sheet into...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers