.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

WHERE IN (SQL)

Posted By:      Posted Date: October 27, 2010    Points: 0   Category :ASP.Net
 

SELECT * FROM dbo.tblItem
WHERE SubCategory in (Convert(INT,@Description_))

in above SP i need to select data using in clause.when i pass 1,3 to the @description  parameter directly within sqlscript it give the correct values.but using sqlparameters it gives following error(will give values to @Description by code behind)

Conversion failed when converting the varchar value '1,3' to data type int.

any idea...

thanks

 




View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend