Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error with SET
Message
De
17/06/2008 13:26:23
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Error with SET
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01324831
Message ID:
01324831
Vues:
53
If I uncomment the two lines in the code below, I get this error:
Msg 156, Level 15, State 1, Line 134
Incorrect syntax near the keyword 'else'
The variable is declared and I am using the same SET with other variables.
if exists (select * from #a where s = @FileName)
	--SET @FileExists = 'Y'
	print @PATH + @Filename + ' exists'
else
	--SET @FileExists = 'N'
	print @PATH + @Filename + ' does not exist'
drop table #a
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform