5299 2
"SqlException: MSDTC on server is unavailable" error in C# Code

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.

...

Type
Question
5137 0
Query in Sql server to list all stored procedures in all databases
In this short article, I have provided simple query using which we can list all stored procedures in all database of SQL server or all stored procedures of specific database.
Type
Article
5076 0
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
4826 3
How should i display first 10 records at a time in sql (paging in SQL)?

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?

...
Type
Question
4767 3
Could not find stored procedure

I am getting SQL Exception when calling stored procedure in my asp.net MVC the exception is : "Could not find stored procedure"

 

...
Type
Question

3794 1
Get sum from three table and selected data using SQL

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

sql-table-fetch-data-from-three-tables-min.png


Table 2. Raw_item

table-2-min.png

Table 3 . inventory_data

table-3-min.png

I try to write query to fetch data from these tables using subquery , Here is my sub query

...
Type
Question
3742 0
Common Table Expressions (CTE) in Sql server
In this article, I have explained what is Common Table Expression (CTE), Advantages of using CTE and Recursive CTE in SQL using SQL server based example.
Type
Article
3676 2
How to solve error "save changes is not permitted" in sql server?

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

...

Type
Question
3384 0
Understanding SQL server COALESCE() with example (ISNULL comparison included)
In this article, I am going to provide you complete details of SQL server COALESCE function with example & will compare it with ISNULL.
Type
Article
3376 0
Uniqueidentifier in SQL Server
In this article, I have provided details about what is uniqueidentifier in sql server, how to create one and use it in SQL Server.
Type
Article

Page 4 of 10