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?...
Hello, I am trying to get Sum of three columns from three different table and get results table using SQL.
Suppose here are my tables
Table 1: raw_item_fcst
Table 2. Raw_item
Table 3 . inventory_data
I try to write query to fetch data from these tables using subquery , Here is my sub query...
I am using SQL server 2012 and when trying to edit design of already saved table, i am getting this error
Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.
Here is the image of the error