SQL插入语句怎么得到自动生成的递增ID值？

[Gozhhu]

SQL插入语句怎么得到自动生成的递增ID值？

我要用自动生成的ID值，怎么办？

[prqin]

select id from table where ...

[chf99cn]

建立数据表时，加一标识列
id int identity (1,1) not null
在存储过程中用
return @@idnetity

[asam2183]

//获取刚插入数据库记录的ID
sql = "insert into table1 (columns1,columns2) values ('1',abc);select @@identity as 'id'";
int i = Convert.ToInt32(Command.ExecuteScalar());

[yhjvc]

来晚了。

[youmukulou]

使用全局函数@@IDENTITY,可以得到递增的ID

[gordenfl]

sql = "insert into table1 (columns1,columns2) values ('1',abc);select @@identity as 'id'";
int i = Convert.ToInt32(Command.ExecuteScalar());

[vitamin_ok]

select max(id)+1 from table

[NetAnt007]

给你个例子：很简单的。
CREATE PROCEDURE sp_Accounts_CreateUser
@EmailAddress varchar(255),
@Password binary(20),
@FirstName varchar(30),
@LastName varchar(30),
@Address1 varchar(80),
@Address2 varchar(80),
@City varchar(40),
@State varchar(2),
@ZipCode varchar(10),
@HomePhone varchar(14),
@Country varchar(50),
@UserID int output
AS
INSERT INTO Accounts_Users(EmailAddress, Password, FirstName, LastName, Address1, Address2,
City, State, ZipCode, HomePhone, Country)
VALUES(@EmailAddress, @Password, @FirstName, @LastName, @Address1, @Address2,
@City, @State, @ZipCode, @HomePhone, @Country)

SET @UserID = @@IDENTITY
RETURN 1

GO
最有用的是SET @UserID = @@IDENTITY这句。

[yunhi]

用存储过程好一些。

[Gozhhu]

在类库中怎么用存储过程？？
int res = (Int32)SqlHelper.ExecuteScalar(trans, CommandType.StoredProcedure, INSERT_REQUIREMENT_COMMAND, RequirementParms);
INSERT_REQUIREMENT_COMMAND怎么写？

用的SqlHelper.