As easily we use the if else statement in stored procedure to check the statement type and there after we perform the desired task. Same thing I want to do using switch case
...When I am trying to run a script of 300mb on SQL Server 2012 I am getting this issue
Cannot execute script: Insufficient memory to continue the execution of the program (mscorlib)here is the image
...
I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.
...
I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"
...
Hi,
im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data.
after setting i should recive an int id of the record that was created.
my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int...
How to retrieve an int from Stored Procedure using EF ???