if object_id('tempdb..#PKefy_Transaction') is null
CREATE TABLE #PKefy_Transaction (TableName varchar(40), OldKey int, NewKey int, RetTimestamp binary(8))
else
DELETE FROM #PKefy_Transaction
DECLARE @o_key int
DECLARE @o_key0 int
DECLARE @o_key1 int
DECLARE @o_key2 int
DECLARE @o_key3 int
BEGIN TRANSACTION ShareD_
insert into BAS_Driver
([Driver_Name],[License],[Vehicle_Shop],[Mobile],[Phone],[E_Mail],[City],[Driver_Type],[Seat],[Memo])
VALUES ('12213','213321','213321','231321','213321','213321','231321','213321','213321','Memo213231')
SET @o_key=scope_identity()
Insert into #PKefy_Transaction (TableName, OldKey, NewKey)
VALUES ('BAS_Driver', 1, @o_key)
COMMIT TRANSACTION ShareD_
SELECT * FROM #PKefy_Transaction
DROP TABLE #PKefy_Transaction
RETURN
ERROR:
BEGIN
ROLLBACK TRANSACTION ShareD_
SELECT err=1
END这是我的原SQL语句,提示是在: SET @o_key=scope_identity() 这句出错,请问是什么原因?
CREATE TABLE #PKefy_Transaction (TableName varchar(40), OldKey int, NewKey int, RetTimestamp binary(8))
else
DELETE FROM #PKefy_Transaction
DECLARE @o_key int
DECLARE @o_key0 int
DECLARE @o_key1 int
DECLARE @o_key2 int
DECLARE @o_key3 int
BEGIN TRANSACTION ShareD_
insert into BAS_Driver
([Driver_Name],[License],[Vehicle_Shop],[Mobile],[Phone],[E_Mail],[City],[Driver_Type],[Seat],[Memo])
VALUES ('12213','213321','213321','231321','213321','213321','231321','213321','213321','Memo213231')
SET @o_key=scope_identity()
Insert into #PKefy_Transaction (TableName, OldKey, NewKey)
VALUES ('BAS_Driver', 1, @o_key)
COMMIT TRANSACTION ShareD_
SELECT * FROM #PKefy_Transaction
DROP TABLE #PKefy_Transaction
RETURN
ERROR:
BEGIN
ROLLBACK TRANSACTION ShareD_
SELECT err=1
END这是我的原SQL语句,提示是在: SET @o_key=scope_identity() 这句出错,请问是什么原因?
你建的是存储过程?
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, 3);
ResultSet rs = ps.executeQuery(); int key = -1;
if (rs.next())
key = rs.getInt(1);