Questions On Sql Server

What is difference between SUBSTR and INSTR in the SQL? Posted by: Tripati_tutu The SUBSTR ca enforce returns a specific bunch of a string representative: SUBSTR(DotNetFunda,6) The finalize bequeathing be: DotNet The INSTR percentage 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 cause 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 nowadays after it is success experty executed. For this successful transaction that is from amaze to end transaction, it follows the term corrosive (Atomicity, Consistency, Isolation, Durability). To implement Database Transaction we fork over to follow the following steps i.e. beginTransaction(); setTransactionSuccessful(); endTransaction(); What is misapprehension handling in stored procedures of SQL waiter 2008? Posted by: Tripati_tutu In previous versions of SQL legion you would handle exceptions by checking the @@ defect global variable immediately after an INSERT, UPDATE or DELETE, and then perform any(prenominal) corrective action if @@error did not equal zero.

SQL Server 2005 provides structured exception handing through and through with(predicate) TRY CATCH contain as other account language like JAVA, C# etc. Example: BEGIN TRY RAISERROR (A frivolity is raised, 16,1) END TRY BEGIN CATCH remove 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 issue forth of the errors. ERROR_SEVERITY() returns the severity. ERROR_STATE() returns the error state number. ERROR_PROCEDURE() returns the visualise of the stored procedure or foundation where the error occurred....If you want to flag 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