Information générale
Forum:
Microsoft SQL Server
Titre:
Use variabe as table name
I like to create a table having name related to the created day. For example,
its name will be Survey20040920 if it is created today. Is it possible?
I used following SQL, but it didn't work.
Declare @Surveyfilename varchar(50)
set @Surveyfilename= 'Survey'+CONVERT(char(8), getdate(), 112)
select * into @Surveyfilename FROM [Survey]
Thanks
Jim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement