mysql select @@indentity_Access中的SELECT @@IDENTITY | 学步园

在Sql Server中可以用ExecuteReader()来同时执行几条一起的Sql语句PetShop 4.0中有如下用法：

using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) {

// Read the returned @ERR

rdr.Read();

// If the error count is not zero throw an exception

if (rdr.GetInt32(1) != 0)

throw new ApplicationException("DATA INTEGRITY ERROR ON ORDER INSERT - ROLLBACK ISSUED");

}

其中cmd对象的Sql语句如下所示(我在调试中取出来的)：

Declare @ID int;

Declare @ERR int;

INSERT INTO Orders VALUES

(@UserId, @Date, @ShipAddress1, @ShipAddress2, @ShipCity, @ShipState, @ShipZip, @ShipCountry, @BillAddress1, @BillAddress2, @BillCity, @BillState, @BillZip, @BillCountry, 'UPS', @Total, @BillFirstName, @BillLastName, @ShipFirstName, @ShipLastName, @AuthorizationNumber, 'US_en');

SELECT @ID=@@IDENTITY;

INSERT INTO OrderStatus VALUES(@ID, @ID, GetDate(), 'P');

SELECT @ERR=@@ERROR;

INSERT INTO LineItem VALUES( @ID, @LineNumber0, @ItemId0, @Quantity0, @Price0);

SELECT @ERR=@ERR+@@ERROR;

INSERT INTO LineItem VALUES( @ID, @LineNumber1, @ItemId1, @Quantity1, @Price1);

SELECT @ERR=@ERR+@@ERROR;

SELECT @ID, @ERR