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 want to select rows from a table where Id is not equal to 4, How to achieve it using SQL query?
Something like in C# .
Where(a=>a.Id != 4).ToList() ?
Or in SQL like
Select * Where Id != 4?
I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"
When I am trying to Edit my tables on my newly installed SQL server management studio, I am getting the error below
Exception has been thrown by the target of an invocation. (mscorlib) Additional information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)
Here is the image of the error