RIG000
چهارشنبه 14 آبان 1393, 12:26 عصر
BEGIN TransAction
Insert into Orders
(CustomerID,OrderDate)
values
(2,GETDATE())
declare @orderid bigint
select @orderid =@@IDENTITY
insert into OrderItems
(OrderID,ItemSKU,ItemPrice,OrederQty)
values
(@orderid,'Hossen tohi','20.96',2)
insert into OrderItems
(OrderID,ItemSKU,ItemPrice,OrederQty)
values
(@orderid,'loca modrich','12.56',3)
commit TransAction
rollBack TransAction
اینم خطاش
(1 row(s) affected)
Msg 8152, Level 16, State 4, Line 12
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 4, Line 17
String or binary data would be truncated.
The statement has been terminated.
Msg 3903, Level 16, State 1, Line 24
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
وفقط اولین insert ثبت میشه ...
Insert into Orders
(CustomerID,OrderDate)
values
(2,GETDATE())
declare @orderid bigint
select @orderid =@@IDENTITY
insert into OrderItems
(OrderID,ItemSKU,ItemPrice,OrederQty)
values
(@orderid,'Hossen tohi','20.96',2)
insert into OrderItems
(OrderID,ItemSKU,ItemPrice,OrederQty)
values
(@orderid,'loca modrich','12.56',3)
commit TransAction
rollBack TransAction
اینم خطاش
(1 row(s) affected)
Msg 8152, Level 16, State 4, Line 12
String or binary data would be truncated.
The statement has been terminated.
Msg 8152, Level 16, State 4, Line 17
String or binary data would be truncated.
The statement has been terminated.
Msg 3903, Level 16, State 1, Line 24
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
وفقط اولین insert ثبت میشه ...