I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one?
For example (Working one)
SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value)
But I am looking for something like this
IF EXIST(SELECT * FROM [Table] WHERE [FIELD1] = Value1 AND [Field2] = Value2)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: