Technical Article

Search for a value in a numeric variable list

When you have a variable that hold a comma separated numbers like '1,2,3' and you have a table with a column that has the value that should match a number in that list, you can use this script to avoid building a string and then executing it.You have to convert the columnID to varchar, the […]

You rated this post out of 5. Change rating

2002-05-20

362 reads

Blogs

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Identify the (Top 20) most expensive queries across your SQL Server using Query Store

By

Script to identify the most expensive queries on your database server using the Query...

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Read the latest Blogs

Forums

TOP with Order By alternative, performance results look mixed

By MMartin1

Hi I have a situation where I am testing two versions of the same...

Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019

By ericwenger1

I'm looking for best practice here and these are Azure VMs by the way....

Azure availability groups requirements question

By Brandie Tarvin

Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers