parameters

External Article

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

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

By

I wrote a post recently about pruning branches in git. That’s part of the...

Microsoft Fabric shortcuts

By

I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...

Develop and Test Your Rollback Plan

By

he rollback plan... what to do when things go wrong to get back to...

Read the latest Blogs

Forums

Blocking question

By SQL Guy 1

Hi all, We have a SSIS package that does 2 things in parallel: moves...

can I monitor auto stats updates through extended events?

By Eric Mamet

We have pretty big tables very sensitive to stats with many updates. Our systems...

SSIS upgrade

By Sailor

I have about 40 packages that are dtsx files that were created with SQL...

Visit the forum

Question of the Day

Post Restore Tasks for the Resource Database

I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?

See possible answers