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
...
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
...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.
...
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 ???
I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"
...
I have Two Tables, from one table I want to select all column but from the second table I want to fetch only one column with average value using avg function with related id
How can I achieve this using SQL query?
...