create trigger tr1 on mytable for insert as exec('exec table mynewtable '+ (select top 1 mycolumn from inserted) )
create trigger tr1 on mytable for insert as declare @a varchar(6000) set @a='MyNewTable'+convert(varchar(100),MyColumn) from instered where... exec('create table '+@a+'(...)') go
for insert
as
exec('exec table mynewtable '+ (select top 1 mycolumn from inserted) )
for insert
as
declare @a varchar(6000)
set @a='MyNewTable'+convert(varchar(100),MyColumn) from instered where...
exec('create table '+@a+'(...)')
go