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
What do you mean by COLLATION?
What is the difference between online clustering and Offline clustering?
How to drop existing indexes in ms sql server?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is an identity column in insert statements?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Write down the syntax and an example for create, rename and delete index?
What are the different types of triggers in SQL SERVER?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
What is data mart? : sql server analysis services, ssas
How do I determine how many instances of sql server are installed on a computer?