declare @i int whlie @i>0 and @i<6 begin endselect colname =
declare @i int declare @date varchar(10) declare @colname varchar(20), @name = varchar(20) whlie @i>0 and @i<6 begin select @colname = col_name(object_id('table'),i) if (exists(slect * from where @colname = 5.8 )) begin set @name = @colname select @date = TIME_STAMP from table where @colname = 5.8 end set @i = @i + 1 end select @name name,@date date
whlie @i>0 and @i<6
begin endselect colname =
declare @date varchar(10)
declare @colname varchar(20),
@name = varchar(20)
whlie @i>0 and @i<6
begin
select @colname = col_name(object_id('table'),i)
if (exists(slect * from where @colname = 5.8 ))
begin
set @name = @colname
select @date = TIME_STAMP from table where @colname = 5.8
end
set @i = @i + 1
end
select @name name,@date date