How to get a list of columns using the "sp_help" 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

What is the maximum size of column in sql server?

0 Answers  


What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  


How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,


Tell me what are the advantages of using stored procedures?

0 Answers  


What authentication modes does sql server support?

0 Answers  






What is acid properties?

0 Answers  


How create table structure only from tableA to TableB if TableA have some data?

4 Answers  


What are the options which must be set to allow the usage of optimistic models?

0 Answers  


What are user defined datatypes and when you should go for them?

1 Answers  


Explain what are sparse columns?

0 Answers  


What is similarity and difference between truncate and delete in sql?

0 Answers  


Define Check points and End Points?

1 Answers  


Categories