SQL

Most Viewed first Recent First
9318 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
8817 1
how to select row where Id is not equal to in SQL?

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

...
Type
Question
8604 0
Difference between Stored procedure and function in SQL Server
This article, lists important difference difference between Stored procedure and function in SQL Server after giving brief details about Stored procedures and functions (user-defined functions) in SQL server.
Type
Article
8559 0
Top SQL tips for beginners (a must read)
Article give details about SQL, tips, and tricks for beginners
Type
Article
8462 0
Best Free SQL Server database hosting
In this article, I have provided list of best free or cheap sql hosting providers available with there features.
Type
Article

8456 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
8240 0
Validate Email address in SQL Server
In this article, I have provided example query, by executing which you can validate email address in SQL Server.
Type
Article
7771 0
SQL Comments (Comment in SQL Query)
In this article, I have provided example to add comment in SQL Query for SQL Server, MySQL and in Postgres
Type
Article
7439 0
SQL Server Management Studio (SSMS) Versions
In this article, I have provided list of all SQL Server management studio (SSMS) versions release by Microsoft until now with it's download links.
Type
Article
7299 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

Page 4 of 11