Search All Articles 
Wednesday, October 19, 2011
How to use Variable in SQL IN Clause
DECLARE @EmpID VARCHAR(8000)
SET @EmpID = '''Emp1'',''Emp2'''
Select * from emp
where empid in(@empid) - This doesnt work...
For solution check the below URL.
http://www.dotnetthread.com/tips/25-Using-variable-in-SQL-IN-statement.aspx
Subscribe to:
Post Comments (Atom)
Also Read other Top Articles
- JSON Serialization in VS 2008
- Implementing Forms Authentication in Silverlight Application.
- Making GridView Rows or Individual Cells Clickable and Selectable.
- Enabling browser back button for GridView Paging and Sorting in Ajax 1.1 and 3.5 (using Visual Studio 2005/ Visual studio 2008)
- How to pass values from User Control to Page or calling Page methods from User Control.
- What is WCF?
- New features in C# 4.0
- C# to VB.NET and VB.NET to C# online free converter tools.
Latest Articles
0 comments:
Post a Comment
Post your comments/questions/feedback for this Article.