here is the code
declare @var table(conz nvarchar(255)) declare @str nvarchar (255) set @str = 'create table tempo( ' insert into @var SELECT [name] AS [Column Name] FROM syscolumns WHERE id = object_id('tablea') select conz from @var print @str
Aucun commentaire:
Enregistrer un commentaire