Exec command in Sqlserver 2008

Question

Exec command in Sqlserver 2008

Priya004

Ten Centuries

Points: 1368
More actions
August 13, 2014 at 5:33 am

#297886

This code says 'Could not find stored proc'
Plz help
declare @a nvarchar
declare @b-2 nvarchar
set @a = (select 'a')
set @b-2 = (select CAST(@a as varchar(10)))
print @b-2
EXECUTE (@b)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What are you trying to do? The code doesn't make any sense.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Cadavre SSC-Forever Points: 41690 More actions · Answer 2

Indu-649576 (8/13/2014)
This code says 'Could not find stored proc'
Plz help
declare @a nvarchar
declare @b-2 nvarchar
set @a = (select 'a')
set @b-2 = (select CAST(@a as varchar(10)))
print @b-2
EXECUTE (@b)

Of course it says that, you're essentially executed: -

EXECUTE a;

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Sean Pearce SSCoach Points: 15999 More actions · Answer 3

This will fix your error message

create procedure a as print 'It Works'

go

declare @a nvarchar

declare @b-2 nvarchar

set @a = (select 'a')

set @b-2 = (select CAST(@a as varchar(10)))

print @b-2

EXECUTE (@b)

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]