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?
C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).
TRUSTED BY
