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);
