query to get column names of table

query to get column names of particular table using sqlserver 2000

select name from SYSCOLUMNS where id=(select id from SYSOBJECTS where name='tablename')

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

query to retrieve top 5 records from table

query to get top 5 records using SqlServer

select top 5 * from tablename
This query displays top 5 records of your table.

select top 5 * from emp.

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs