Questions On Sql Server

What is difference between SUBSTR and INSTR in the SQL?

Posted by: Tripati_tutu
The SUBSTR power returns a specific portion of a string
Example: SUBSTR(DotNetFunda,6)
The root willing be: DotNet

The INSTR function 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 work 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 committed immediately after it is successfully executed. For this successful transaction that is from begin to end transaction, it follows the term corrosive (Atomicity, Consistency, Isolation, Durability).

To implement Database Transaction we have to follow the following stairs 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 exceptions by checking the @@ defect global variable immediately after an INSERT, UPDATE 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:
BEGIN TRY

RAISERROR (A caper is raised, 16,1)

END TRY

BEGIN CATCH

SELECT 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 number of the errors.
ERROR_SEVERITY() returns the severity.
ERROR_STATE() returns the error state number.
ERROR_PROCEDURE() returns the realise of the stored procedure or trigger where the error occurred....If you want to loll around a full essay, order it on our website: Orderessay



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