Dynamic Where Query in SQL Server
In this article, I will give information about the use of dynamic where query in SQL Server.
In SQL Server, in some cases, you may want to use two or more where conditions dynamically.
I created the following code based on the Northwind database. You can use it according to your own database or according to the Northwind database.
DECLARE @WhereSentence1 NVARCHAR(MAX), @WhereSentence2 NVARCHAR(MAX); SELECT @WhereSentence1 = N' AND TitleOfCourtesy=''Ms.''', @WhereSentence2 = N' AND City = ''London'''; DECLARE @SQLSentence NVARCHAR(MAX); SELECT @SQLSentence = N'SELECT * FROM Employees WHERE EmployeeID=9 ' + @WhereSentence1 + @WhereSentence2; PRINT @SQLSentence; EXEC sys.sp_executesql @SQLSentence;
When you run the code, you will get a result like the one below.
As you can see, we have used two where clauses dynamically.
Good luck to everyone in business and life.