You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Pass Where clause dynamically in Microsoft SQL

Accepted answer
8
Views
4
Comments
edited Aug 17, 2021 4:40AM in Integration 4 comments

Content

Hi,

I need to pass where clause conditions value dynamically while running sql statements for Microsoft SQL. Here is my query: 

SELECT *
FROM [ServicePackTest].[dba].[s1_name_and_address] 
WHERE name_and_address_id  =  #id

But this doesn't work. Please advise.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!