Error handling technique in SQL Server
Write down the latest error handling technique in SQL Server 2005?
Expert
SQL Server 2005 launches a latest exception handling paradigm using CATCH or TRY blocks in T-SQL. The errors are fine trapped in the try block and the execution is passes back to the catch block. The conditions such as using cursors… the cursor is assigned for opening in the TRY block at the time of happening an error is thrown to CATCH block to verify whether it is open. when it is open, it must be close and de-allocate.
Illustrates the cursors in brief?
Describe briefly Recovering sessions?
Write a brief note on the difference between data and database administration?
Write down a short note on the difference between an ERD and EER.
Which data providers can be combined in one report?
Illustrates the applications of ASA?
Briefly explains the three kinds of SQL commands?
State some of the sectors where the data warehousing and data mining are utilized.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Give a brief introduction of the term non-additive facts?
18,76,764
1926027 Asked
3,689
Active Tutors
1457653
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!