sp_executesql returning blank resultset

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

sp_executesql returning blank resultset

Author

Topic

subhaoviya
Posting Yak Master

135 Posts

Posted - 2013-05-08 : 06:41:05

hi while i am executing the below query, i am getting resultset with columns but no data.

DECLARE @sql NVARCHAR(max)
DECLARE @params NVARCHAR(4000)

SET @sql=N'exec MyStoredProcedure'
SET @params = N' @POSTCODE VARCHAR(20), @SURNAME VARCHAR(50),@HOMEPHONE VARCHAR(20),@MOBILE VARCHAR(20)
,@EMAIL VARCHAR(120) ,@D_INDIVIDUALID VARCHAR(200),@P_LEADID VARCHAR(200)'

EXECUTE SP_Executesql @sql,@params,'','','','','',1,''

but when i am executing
exec MyStoredProcedure @D_INDIVIDUALID =1

please help me to resolve the issue with sp_executesql

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-08 : 06:49:39

it should be


DECLARE @sql NVARCHAR(max) 
DECLARE @params NVARCHAR(4000)

SET @sql=N'exec MyStoredProcedure @POSTCODE,@SURNAME,...'
SET @params = N' @POSTCODE VARCHAR(20), @SURNAME VARCHAR(50),@HOMEPHONE VARCHAR(20),@MOBILE VARCHAR(20)
,@EMAIL VARCHAR(120) ,@D_INDIVIDUALID VARCHAR(200),@P_LEADID VARCHAR(200)'


EXECUTE SP_Executesql @sql,@params,@POSTCODE=<value>,@SURNAME=<value>,...

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

subhaoviya
Posting Yak Master

135 Posts

Posted - 2013-05-08 : 06:57:20

Thanks a lot visakh it is working fine .

zhulin

3 Posts

Posted - 2013-05-08 : 09:32:21

Thank you for sharing. Hope you will share more ideas and pictures, I wish you good luck.

__________________
zhulin
unspammed

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-08 : 12:31:32

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources