Answer / anil panwar

SP_help < table_name>

Answer / vidit tyagi

sp_help <tablename>

Answer / krishnaraj

sp_help '<TABLE NAME>'

Answer / erwin suryana

sp_columns <table_name>

Answer / ram

sp_help <table name>

Answer / sathish

how can i view structure of table in sql server? tell me
that query.

Select * from information_schema.columns where table_name =
xyz

Answer / r.rajesh

sp_columns table_name

Answer / sagar

Select TableName and then press ALT+F1 means highlight tablename

Answer / murli manohar

sp_tables @table_type = "'TABLEName'"

Answer / justus

sp_helptext <tablename>

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

What is sql collation?

0 Answers  

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

Explain about analysis services?

0 Answers  

What is the osql utility?

0 Answers  

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

What is the order by used for?

0 Answers  

Does a full backup include transaction log?

0 Answers  

Why should you use or avoid select * statements?

0 Answers  

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

What is self contained sub query?

0 Answers