Database/MSSQL
MSSQL|Dynamic SQL 예제 (다이나믹 쿼리)
어느가을빛
2009. 12. 30. 10:36
declare @sql varchar(100);
if @key = '1' then
select @sql = 'select a,b from rich';
else
select @sql = 'select a,c,b from rich';
end if;
execute immediate(@sql);