Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Still working on indirection query
Message
From
05/02/2007 09:46:25
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01192348
Message ID:
01192387
Views:
18
Similar to the previous example.

This section fails in SQL Analyzer with:
"A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations."
DECLARE @ParamDeff nvarchar(2000)
SET @ParamDeff = '@Column2Get3Out char(20) OUTPUT,  @Column2Get4Out char(20) OUTPUT'

EXECUTE sp_executesql @sSQL, @ParamDeff,  @Column2Get3Out =@Column2Get3 OUTPUT, @Column2Get4Out = @Column2Get4 OUTPUT


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform