Server Story..../MSSQL
중복 제거후 select 값을 insert 하는 과정 쿼리
Sumin Family
2014. 7. 23. 16:32
변수선언
declare @tname varchar(50)
declare @totalname varchar(200)
set @tname='t_user_test'
set @totalname = 'insert into ' + @tname + ' select DISTINCT * from [34].[testc].[dbo].[' + @tname + ']'
exec (@totalname)