How to get a list of columns in a view using the "sp_columns" stored procedure?


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

Post New Answer

More SQL Server Interview Questions

What do you mean by a Composite primary key?

0 Answers   Genpact,


How do I open a .db file?

0 Answers  


Differentiate between sql temp table vs table variable?

0 Answers  


How do you manipulate data?

0 Answers  


What do you understand by recursive stored procedure?

0 Answers  






How do you check the performance of a query and how do you optimize it?

1 Answers  


What do you understand by coalesce in sql server?

0 Answers  


List out different types of normalizations in sql server and explain each of them?

0 Answers  


Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  


Can we perform backup restore operation on tempdb?

0 Answers  


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  


How many types of functions are there in sql server?

0 Answers  


Categories