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...
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
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?