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

Can we use trigger new in before insert?

0 Answers  


Is the primary key column of a table an index in ms sql server?

0 Answers  


What are the transaction properties?

0 Answers  


Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  


Explain temporary table vs table variable by using cursor alternative?

0 Answers  






What is the contrast between sql and mysql?

0 Answers  


What are the differences between substr and charindex in sql server.

0 Answers  


Explain couple pf features of SQL server

2 Answers  


What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  


How to Check if table exists in sql server?

0 Answers  


i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,


Categories