Logo 
Search:

SQL Server Forum

Ask Question   UnAnswered
Home » Forum » SQL Server       RSS Feeds

Error on Col_Name()

  Asked By: Heinrich    Date: May 05    Category: SQL Server    Views: 823
  

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

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Error on Col_Name() Or get search suggestion and latest updates.




Tagged: