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 create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

How can change procedure in sql server?

0 Answers  

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

What is unique key constraint?

0 Answers  

What do you mean by collation recursive stored procedure?

0 Answers  

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

What will be query used to get the list of triggers in a database?

0 Answers  

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

What are commonly used odbc functions in php?

0 Answers