日期:2014-05-16  浏览次数:20391 次

往MS server数据库插入一条记录并返回这条记录的ID
CREATE?procedure?pr_AddProduct
????
@ChineseName?nvarchar(50),
????
@Supplier?text,
????
@Material?nvarchar(50),
????
@SGW????????nvarchar(50),
????
@TPI????????text????,
)
??
Declare?@ProductId?int
insert?into
Product
ChineseName,
EnglishName,
MOQ,
size,
CategoryID,
RSC
VALUES
????
@ChineseName?,
????
@Supplier?,
????
@Material?,
????
@SGW????????,
????
@TPI????????,