Posted by ArunDhaJ on 07/02/07 08:37

Hi Friends,
Help me in retrieving a table with a SNo column

Select Name From SysObjects Where type = 'U' Order By Name asc

the above query would fetch the Table names. as

Name
Table1
Table2
Table3
Table4

i need a view which should also include the serial number

SNo Name
1 Table1
2 Table2
3 Table3
4 Table4

Regards,
ArunDhaJ

• Next in forum: Re: Select with serial number column
• Prev in forum: Re: Performance between Standard Join and Inner Join
• Thread view: Select with serial number column

[Reply to this message]