SET XACT_ABORT ON BEGIN TRAN INSERT INTO SystemUsers (usr_us_id) SELECT us_pk FROM SFSUsers LEFT OUTER JOIN SystemUsers ON us_pk = usr_us_id WHERE usr_us_id IS NULL INSERT INTO Addresses (add_usr_id) SELECT usr_id FROM SystemUsers LEFT OUTER JOIN Addresses ON usr_id = add_usr_id WHERE add_usr_id IS NULL COMMIT TRAN END
public int SynchronizeWithSecurity() { sqlCommandBuilderApp oSQLCmd = new sqlCommandBuilderApp("SystemUsers_SynchronizeWithSecurity",CommandType.Text); int numberSynched = Convert.ToInt32(ExecuteScalar(oSQLCmd.SqlCmd)); return (int)numberSynched; }
DECLARE @inserted INT SET @inserted = 0 INSERT .... SET @inserted = @@ROWCOUNT INSERT ... SET @inserted = @inserted + @@ROWCOUNT SELECT @inserted AS ReturnedValue
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)