How to Handle the exceptions in Sqlsrver 2005??
Answer Posted / manikanta.srinu
Sqlsrver 2005 introduced try-catch block in SQL. orelse you
can use Transation to Handle error in SQL
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the system function to get current user's user id? : Sql server database administration
Which are ddl commands?
What is the name of reporting services config file and what’s it’s used for?
What is tempdb in sql server?
How do I completely remove sql server instance?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
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?
what is the system function to get the current user's user id? : Sql server database administration
what are the different stages of Report Processing?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain syntax for viewing, dropping and disabling triggers?
When would you use the stored procedures or functions?
How to enter comments in transact-sql statements?
Explain indexed views?
Explain the use of containers in ssis and also their types?