how can i view structure of table in sql server? tell me
that query.
Answer Posted / vidit tyagi
sp_help <tablename>
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Explain Reporting Life Cycle?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is meant by datasource?
If the job running very slow what is the action you do
What are the advantages of mirroring?
What are the types of dml?
What are basics of policy management?
Define outer join in sql server joins?
Mention the 3 ways to get a count of the number of records in a table.
When we should use and scope of @@identity?
What will happen if a column containing char type data is changed to the nchar data type?
What to perform pattern match with the like operator?
How many full-text indexes can a table have?
What is transact-sql language?
Describe how to use the linked server?