Hi,
there is table EMPLOYEES wich has 8 columns.
In a loop Col_Name() provides names only for the first 4 columns.
code:
while @j<9
begin
set @col=Col_Name(object_ID('dbo.EMPLOYEES'),@j)
print @col
set @j=@j+1
end
Thanks a lot in advance for any help.
HO