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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Velemoochi
Imran Ghani
Post New Web Links

SP- Where In

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

hi all,

below is my sp

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

alter PROCEDURE [dbo].SAMPLE1(@inpCity Nvarchar(30))
    
AS
BEGIN
    SET NOCOUNT ON;
    SELECT City  FROM Person.Address where City In (@inpCity)
END


now im calling this sp by this

exec SAMPLE1 'Bothell';

its working fine, now i have call like this

exec SAMPLE1 'Bothell,Calgary';

but i didnt get the result, may i know what is the error and how to solve this?




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