ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
how to know description of a table in sqlserver 2000
 Question Submitted By :: E-mail
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how to know description of a table in sqlserver 2000
Answer
# 1		 
desc <table_name>
 
Is This Answer Correct ?    1 Yes 3 No
Srinivas
 
  Re: how to know description of a table in sqlserver 2000
Answer
# 2		 
sp_help <table_name>
 
Is This Answer Correct ?    2 Yes 0 No
Kmbkrishnan
 
 
 
  Re: how to know description of a table in sqlserver 2000
Answer
# 3		 
Dear Srinivas,
desc using in oracle not in Sql Server.
sp_help <table_name> is correct answer for Sql server
 
Is This Answer Correct ?    3 Yes 0 No
Ksantosha
 
  Re: how to know description of a table in sqlserver 2000
Answer
# 4		 
sp_ help table name
   is the correct answer  , above two  answer is correct
 
Is This Answer Correct ?    2 Yes 0 No
Ritesh
 
  Re: how to know description of a table in sqlserver 2000
Answer
# 5		 
sp_help is the correct answer.
 
Is This Answer Correct ?    2 Yes 0 No
Punithalakshmi
 
  Re: how to know description of a table in sqlserver 2000
Answer
# 6		 
Yes The Ksanthosha Given the Right Answer!

SP_HELP TABLE_NAME

This will gives the descriptin about the given TABLE_NAME
 
Is This Answer Correct ?    1 Yes 2 No
Sharif
 
  Re: how to know description of a table in sqlserver 2000
Answer
# 7		 
by pressing alt+f1 we also  get the description of the table
 
Is This Answer Correct ?    4 Yes 0 No
Rajeev
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What does it mean to have quoted_identifier on? What are the implications of having it off?  2
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE IBM1
What are the steps you will take to improve performance of a poor performing query? HCL1
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.  2
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2 HCL2
explain different types of jions with examples briefly? Zensar2
What are the authentication modes in SQL Server?  2
what is the Enterprise manager(2000) and management studio (2005)?  2
Write a query to delete duplicate records in SQL SERVER Infosys19
Difference between Function and Stored Procedure? C1-India4
I have to display ten columns values from diffrent ten tables. how many joins are require? HCL8
Explain sp_configure commands, set commands?  3
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
Can we rewrite subqueries into simple select statements or with joins? Example? ASD1
What is the difference between having and where clause?  4
what is for foreign key ?? Sabic3
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same? Microsoft2
What is the difference between constraints and triggers? Wipro6
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs. APX2
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?  3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com