SQL Transaction command Use

-
·       Transaction Command



This Command is use to
Perform Two  more commandExecute in one Time .
If Any insert queary is fail thanOther queary is Rollback .

Example :

CREATE PROCEDURE [dbo].[insertDatePROCE]
AS
BEGIN TRY
BEGIN TRAN
INSERT INTO test
(
studentname,
std,
IsActive,
CreationDate,
studentAddress
)
values
(
'BHAVYA',
6,
1,
GETDATE(),
'RAJKOT'
);
INSERT INTO test
(
studentname,
std,
IsActive,
CreationDate,
studentAddress
)
values
(
'JAYRAJ',
8,
1,
GETDATE(),
'RAJKOT'
);
INSERT INTO test
(
studentname,
std,
IsActive,
CreationDate,
studentAddress
)
values
(
'URVEE',
7,
1,
GETDATE(),
'AHEMDABAD'
);
COMMIT TRAN
END TRY

BEGIN CATCH
ROLLBACK TRAN
END CATCH

Comments

Post a Comment

Popular posts from this blog

Search Record From Table Using jQuery in Asp.net core MVC

-
Table Code : <div class="row">     <div class="col-md-12">         <div class="card">             <div class="card-body">                 <div class="">                     <table id="tblAccount" class="table table-bordered">                         <thead>                             <tr>                                 <th>Account </th>                                 <th>Website</th>                             ...
Read more

How To insert Radio Button Data in DataBase -- MVC

-
View code :   <div class="form-horizontal">         <h4>MyRadioButtonDemo</h4>         <hr />         @Html.ValidationSummary(true, "", new { @class = "text-danger" })         <div class="form-group ">             @Html.LabelFor(model => model.Gender, htmlAttributes: new { @class = "control-label col-md-2" })             <div class="col-md-10 " >                 <label class="radio-inline">                     @Html.RadioButtonFor(model=>model.Gender,"Male",new { @name="gender"})                     male                 </label>                 <...
Read more

Toolbox Webparts Controls

-
Image
Introduction Toolbox is very-very important building block of .NET Framework. Toolbox is an area where all the controls existed. It helps the developer to develop any application very quickly, only drag the control from the toolbox and drop it on the form. To change its properties we have to select the control and make the properties changes from Properties window. We can do it manually by writing code-behind. There are over 100 controls available in ASP.NET 4.0. I am listing here all the controls available in ASP.NET 4.0 and writing some lines on each of them.   6. WebParts Controls: This section includes features like personalization of website. Using the controls given in this section user can modify the content, appearance, styles, and behaviors of web page directly from web browser. User can personalize the web application dynamically without having developer or administrator rights. Such changes can be applied to entire web application or only to individual users. ...
Read more