110,536
社区成员
发帖
与我相关
我的任务
分享
string sql = "insert into table1 (name) values('a');select SCOPE_IDENTITY()";
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.ExecuteScalar();//这里执行完后返回的就是你要的id了.
CREATE TABLE [table1] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [varchar] (50) NULL ,
CONSTRAINT [PK_table1_1] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
insert into table1 (name) values('a');select SCOPE_IDENTITY()--这语句执行后获得的就是我刚插入的id
create proc proc_name
as
begin
begin tran
declare @id int
insert into ta(id,name) select 1,'a'
set @id=scope_identity()
insert into tb(id,name) select @id,'b'
commit tran
end
OracleConnection con = dbclass.GetOracleConnection();
OracleCommand com = new OracleCommand();
//用事务对数据进行多表插入
com.Connection = con;
com.Transaction = con.BeginTransaction();
try
{
//.....要插入的方法语句
com.Transaction.Commit();
return true;
}
catch (Exception ee)
{
com.Transaction.Rollback();
string error = ee.Message.Replace("'", " ");
return false;
}