Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Still working on indirection query
Message
De
05/02/2007 09:46:25
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01192348
Message ID:
01192387
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform