Answer Posted / somu
2
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is built-in function?
What do you understand by a view? What does the with check option clause for a view do?
What are different types of roles provided by ssrs?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Explain what is use of dbcc commands?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Define Unique Key?
How many null values we can have in a unique key field in sql server?
List all types of constraints in sql server?
What are tables in sql server?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?