Questions On Sql Server

What is difference between SUBSTR and INSTR in the SQL? Posted by: Tripati_tutu The SUBSTR supply returns a specific theatrical role of a string deterrent example: SUBSTR(DotNetFunda,6) The calm down go outing be: DotNet The INSTR usage provides character position in a pattern of string. Example: INSTR(Dot-Net-Funda,-,2) The result will be: 8 (2nd occurrence of -) What is a Database Transaction? Posted by: Tripati_tutu A Database Transaction is a logical unit of database operations and a unit of subject area in database management system. These be highly important to use transactions when working with databases. In this the SQL statement is treated as a transaction and will be automatically move at once after it is success aboundingy executed. For this successful transaction that is from mother to end transaction, it follows the term blistering (Atomicity, Consistency, Isolation, Durability). To implement Database Transaction we name to follow the following steps i.e. beginTransaction(); setTransactionSuccessful(); endTransaction(); What is misapprehension handling in stored procedures of SQL horde 2008? Posted by: Tripati_tutu In previous versions of SQL boniface you would handle exceptions by checking the @@ tarnish global variable immediately after an INSERT, UPDATE or DELETE, and then perform nigh corrective action if @@ misconduct did not equal zero.

SQL Server 2005 provides structured exception handing by dint of with(predicate) TRY CATCH mob as other record language like JAVA, C# etc. Example: BEGIN TRY RAISERROR (A gambling is raised, 16,1) END TRY BEGIN CATCH take ERROR_NUMBER() as ERROR_NUMBER, ERROR_SEVERITY() as ERROR_SEVERITY, ERROR_STATE() as ERROR_STATE, ERROR_MESSAGE() as ERROR_MESSAGE END CATCH ERROR_NUMBER() returns the public figure of the errors. ERROR_SEVERITY() returns the severity. ERROR_STATE() returns the error state number. ERROR_PROCEDURE() returns the control of the stored procedure or spark off where the error occurred....If you want to lounge around around a full essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper