parameters

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.

2018-07-05

3,805 reads

Blogs

Interview with Greg Low

By

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

Azure SQL Database Types

By

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

Azure SQL Database – Azure Portal Updates

By

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

Read the latest Blogs

Forums

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

By SREENIVAS

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

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers