I have a Table named Department and I update it inside an SP which insert records into multiple tables.
Update Department SET NewId= @NewId WHERE OldId=@OldId
Where @NewId,@OldId are parameters. When called through SP this does not happen.
But when i execute this through SSMS by passing the parameters, Update happens. Literally have no clue about this.