var pramTotalRowCount = new SqlParameter("@PKID", SqlDbType.Int) { Direction = ParameterDirection.Output }; var parameters = new[] { new SqlParameter("@ID", srcs.ShopID), new SqlParameter("@Name", srcs.UserName), pramTotalRowCount }; string sql = @"INSERT INTO Tuhu_shop..ShopReceiveCheckSecond ( ID , Name ) VALUES ( @ID , @Name); SET @PKID = SCOPE_IDENTITY();"; SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sql, parameters); long pkid = 0; long.TryParse(pramTotalRowCount.Value.ToString(), out pkid); return pkid;
sql SCOPE_IDENTITY()
最新推荐文章于 2022-04-01 16:58:26 发布