Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set vs Exec
Message
From
11/01/2008 10:14:29
Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01281129
Message ID:
01281152
Views:
7
Sorry it's not work.
It did some tests. My value return always 0.

Here's a sample...
declare @x int
exec @x = SP1
select @x

result: 0

Normally, SP1 should be return a value.

Create procedure SP1 as
declare @Y int
set @y = 1
select @y

Thank.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform