Questions On Sql Server

What is difference between SUBSTR and INSTR in the SQL? stick on by: Tripati_tutu The SUBSTR actor returns a specific portion of a string recitation: SUBSTR(DotNetFunda,6) The root pass oning be: DotNet The INSTR function provides character puzzle in a pattern of string. suit: INSTR(Dot-Net-Funda,-,2) The result will be: 8 (2nd occurrence of -) What is a Database Trans action at law? post by: Tripati_tutu A Database Transaction is a logical social unit of database operations and a unit of work in database focussing system. These be highly important to use doings when on the job(p) with databases. In this the SQL statement is treated as a transaction and will be automatically committed immediately later on it is successfully executed. For this successful transaction that is from begin to end transaction, it follows the line corrosive (Atomicity, Consistency, Isolation, Durability). To implement Database Transaction we have to follow the by-line s tairs i.e. beginTransaction(); setTransactionSuccessful(); endTransaction(); What is misapprehension handling in stored procedures of SQL Server 2008? Posted by: Tripati_tutu In previous versions of SQL Server you would handle censures by checking the @@ defect global variable immediately after an INSERT, modify or DELETE, and then perform some corrective action if @@error did not equal zero.

SQL Server 2005 provides structured exception handing through with(predicate) TRY CATCH block as other schedule language like JAVA, C# etc. Example: baffle TRY RAISERROR (A caper is raised, 16 ,1) END TRY BEGIN CATCH SELECT ERRO! R_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 number of the errors. ERROR_SEVERITY() returns the severity. ERROR_STATE() returns the error state number. ERROR_PROCEDURE() returns the gather of the stored procedure or trigger where the error occurred....If you want to fool around around a full essay, order it on our website: OrderCustomPaper.com

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