Update Statement does not work when called through C# Application

by Srinivasan Rajasekaran   Last Updated September 11, 2019 17:26 PM

I have a Table named Department and I update it inside an SP which insert records into multiple tables.

I user 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.

Tags : sql sql-server


Related Questions


Updated November 20, 2017 05:26 AM

Updated February 17, 2016 02:11 AM

Updated December 06, 2017 20:26 PM

Updated August 24, 2017 04:26 AM

Updated March 08, 2018 18:26 PM