Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set vs Exec
Message
 
 
To
11/01/2008 09:10:12
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:
01281142
Views:
7
EXEC @x = SP1
>
>Is it possible to assign an return value from an Stored Proc to a variable locale.
>
>My first SP return a value.
>I want that my second SP exec that first SP in the second.
>
>Example:
>Declare @x int
>set @x = exec SP1
>select @x
>
>I got an error.
>
>Thank in advance.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform