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?
Thanks
...One of my projects was working properly, and then I shifted it into another pc, now same code, throws the below error for some SQL queries.
SqlException: MSDTC on server is unavailable....
How should i display 1st 10 records, then next 10 records then next 10 records in sql (paging in SQL)?
And how should i display the same thing in view using see more link?
...I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"
...