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

Azure Database for PostgreSQL

By

Having worked with Azure SQL Database and its many flavours for couple of years...

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.

By

I realized in my last #PowershellBasics post that I was talking about running a...

Read the latest Blogs

Forums

Extract part of string

By Mad-Dog

hi, How can I extract part of this string declare @string varchar(1024) set @string...

Data type conversion error

By as1981

All, This is my data flow: I'm getting the error: "Error: 0xC02020A1 at Data...

Processing Multidimensional cubes

By richardmgreen1

Hi all   We currently have a multidimensional database that contains 5 cubes. We...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers