Important Sql Server 2000 Queries !!

I'll try to add some important Sql Server Queries in the below post.
This will be handy for me some day.

Q1 : To select Column Names from a table:

SELECT column_name

FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_name= 'YOUR TABLE NAME'