Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT x AS 'y'
Message
De
03/02/2009 12:54:36
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
SELECT x AS 'y'
Divers
Thread ID:
01379000
Message ID:
01379000
Vues:
79
I bet Sergey can figure out a way to do this!

If I have the following SQL statement, it works fine:

SELECT CodesKey AS 'codesdeptkey', * from codes

I'd like to parameterize this, but if I try this it gives an incorrect syntax error:

DECLARE @KeyName varchar(50)
SET @KeyName = 'codesdeptkey'
SELECT CodesKey AS @KeyName, * from codes

Any ideas??? (other than obvious setting a string to the whole SELECT string and then EXECing that ... the SELECT string is obviously more complicated than what I've indicated above).

TIA,
~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform