Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the raise event used for?

Answer Posted / vini778

It is used for raising the error from sql statement
Eg shown below

IF @@TRANCOUNT>0 ROLLBACK TRANSACTION
Raise an error with the details of the
exception
DECLARE @ErrorMessage NVARCHAR
(
MAX
)
DECLARE @ErrorSeverity INT;
DECLARE
@ErrorState INT;
SELECT
@ErrorMessage=ERROR_MESSAGE
(
)
,
@ErrorSeverity=ERROR_SEVERITY
(
)
,
@ErrorState=ERROR_STATE
(
)
;
-- Use RAISERROR inside the CATCH
block to return error
-- information about the original
error that caused
-- execution to jump to the CATCH
block.
RAISERROR
(
@ErrorMessage,-- Message
text.
@ErrorSeverity,--
Severity.
@ErrorState -- State.
)
;

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is garbage collection? Explain the difference between garbage collections in .net 4.0 and earlier versions?

1049


What are multicast delegates?

1013


What is the difference between .net and laravel?

963


What is Full trust permission set in .Net

2297


What is the intermediate language between asp and asp.net1.0?

1921


Difference between value type & reference types ?

1011


What is the root class in .net?

1076


What method do you use to explicitly kill a users session? How?

963


What is the difference between .net 2000 and .net 2005(features)? Which one is better?

918


How do we access crystal reports in .net?

1055


What is dot net and its uses?

952


What is the base class of Button control in .NET?

1028


Explain the difference between static page and dynamic page?

916


Is .net core the future?

956


Explain what is the difference between encrypting a password and applying a hashing?

1025