sql SCOPE_IDENTITY()

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;