rwheeler23
asked on
C# proper use of executescalar
I have a sql stored procedure that populates a table in MSSQL. I also have a second stored procedure that will issue the truncate table command on that same table after the user is done using that table. Am I correct in using:
executenonquery since it is issuing INSERT statements on the first sp
executescalar because no return results are expected on the second sp
If I call the second sp this way object result = sqllCommand.ExecuteScalar();
what exactly would the value returned be?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.