How to get a list of columns in a view using the "sp

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

Question Posted / sanjeev saxena

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

More SQL Server Interview Questions

Diffrences between sql server 2000 vs 2008

What Are Three Rules to Use UNION IN SQL SERVER

Issues related in upgrading SQL Server 2000 to 2005 / 2008

How are the exceptions handled in sql server programming?

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

Do you know what is a trace frag? Where do we use it?

What are the different types of locks in the database?

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

How to turn off warning messages during php execution?

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

Can group functions be used in the order by clause in ms sql server?

What happens if you are trying to access a schema not owned by you?

For more SQL Server Interview Questions Click Here