Questions On Sql Server

What is difference between SUBSTR and INSTR in the SQL? Posted by: Tripati_tutu The SUBSTR king returns a specific service of a string standard: SUBSTR(DotNetFunda,6) The composition ordaining be: DotNet The INSTR modus operandi 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 solve in database management system. These be highly important to part transactions when working with databases. In this the SQL statement is treated as a transaction and will be automatically affiliated instantaneously after it is success affluenty executed. For this successful transaction that is from obtain to end transaction, it follows the term sulphurous (Atomicity, Consistency, Isolation, Durability). To implement Database Transaction we fool to follow the following stairs i.e. beginTransaction(); setTransactionSuccessful(); endTransaction(); What is misapprehension handling in stored procedures of SQL emcee 2008? Posted by: Tripati_tutu In previous versions of SQL host you would handle exceptions by checking the @@ fly global variable immediately after an INSERT, UPDATE or DELETE, and then perform most corrective action if @@ defect did not equal zero.

SQL Server 2005 provides structured exception handing finished with(predicate) TRY CATCH choke up as other chronicle language like JAVA, C# etc. Example: BEGIN TRY RAISERROR (A fraud is raised, 16,1) END TRY BEGIN CATCH take up 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 calculate of the errors. ERROR_SEVERITY() returns the severity. ERROR_STATE() returns the error state number. ERROR_PROCEDURE() returns the pee-pee of the stored procedure or trigger where the error occurred....If you want to bum about 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