How to get a list of columns using the "sp

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

Question Posted / sanjeev saxena

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

More SQL Server Interview Questions

Explain what are the different index configurations a table can have?

What is query cost in sql server?

Explain sql server authentication modes?

Explain subquery and state its properties?

How to retrieve error messages using mssql_get_last_message()?

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

If we use where clause in the left outer join then how the query would behave/act?

List out the difference between union and union all in sql server?

How to recompile stored procedure at run time?

What is the use of @@spid?

What are the different types of subquery?

How to use old values to define new values in update statements in ms sql server?

For more SQL Server Interview Questions Click Here