Using Parameters for SQL Server Queries and Stored Procedures

  • Article

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.


3,805 reads


Interview with Greg Low


This is the sixth interview we have done. This time our guest is Greg...

Azure SQL Database Types


I want to do a quick summary post of the many different types of...

Azure SQL Database – Azure Portal Updates


A small but useful change has been made to the Azure Portal for Data...

Read the latest Blogs


Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Dynamically Automate SQL database restore script


Hi All, In my environment, we are getting huge account of refresh activities coming...

Should I execute Rebuild\\Update Statistics Job after failover in Always on

By anujkumar.mca

Folks, Please help me with below query. I have two instance Inst1 and Inst1...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers