1726 0
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
1657 0
Row constructor in SQL server (Explanation With example)
This article gives a quick explanation about Row constructor (Table value constructor) in SQL server with various usage example
Type
Article
1565 1
Sum of two column values from two different tables

I want sum of two column values from two different tables, how can I do it using SQL?

Suppose, these are my two tables, Table 1

...
Type
Question
1366 0
Creating SQL Server maintenance plan (Step by step procedure)
In this article, I am going to explain, how can we easily create SQL server maintenance plan by following this step by step procedure and how often we should plan it.
Type
Article
1341 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

1304 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
1241 1
"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
1229 1
Database Threats and how to Prevent them

I am tasked with security of the systems database, as the previous operation lacked security and left gaping holes in the system. The Systems information was leaked, and clients records were leaked as well as workers salaries. I need to find One technique or strategy to prevent this information loss, and propose how we will prevent this in future. I am relatively new to DBMS, can you please help me.

...
Type
Question
1196 2
How to retrieve an int from Stored Procedure and not an objectResult using EF ???

Hi,

 

im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data.

after setting i should recive an int id of the record that was created.

my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int...

How to retrieve an int from Stored Procedure using EF ???

...
Type
Question
1180 1
how to take back up of all sql server databases?

I am using SQL server 2012 right, and I would like to know how can I take back up of all MS SQL server databases using a single script? or you can explain me a simple method.

 

...
Type
Question

Page 3 of 6