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>

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  

Do you know what is lock escalation?

0 Answers  

What are transactions and its controls?

0 Answers  

What are information schema views?

0 Answers  

What are the diifferences between the ms sql server vs mysql?

0 Answers  

Explain the xml support sql server extends?

0 Answers  

Explain about link server in sql server?

0 Answers  

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

How to concatenate two strings in SQL Server.

0 Answers   HCL,

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers