How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Why the trigger fires multiple times in single login?

0 Answers  


How to choose all records from the table?

0 Answers  


if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,


Define the term DML, DDL and DTL?

1 Answers  


Mention the different types of triggers?

0 Answers  






How can windows applications connect to sql servers via odbc?

0 Answers  


What is the difference between char and varchar2 datatype in sql?

0 Answers  


What is the use of group by clause?

0 Answers  


What is the difference between a "where" clause and a "having" clause?

0 Answers  


How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,


What is an execution plan? When would you use it?

0 Answers  


What is the need for group functions in sql?

0 Answers  


Categories