Latest posts on "SQL"

SQL guide -SQL - Structured Query Language

17 January 2018

SQL is the standard computer language for accessing and manipulating databases. Commonly used database management system: MySQL, SQL Server, Access, Oracle, Sybase, and DB2 For those who want to store and retrieve data from the database, SQL knowledge is unmeasurable.

Export SQL query results to Excel?

7 October 2017

In this video tutorial I will show how to export SQL Query results to excel using Microsoft SQL Server. After executing the SQL Query, in the results pane, click the top-left cell to highlight all the records, and then right-click the top-left cell and click "Save Results As" and give any name for it.

Custom Paging SQL Server example

28 November 2016

In this article, I will show you how to implement custom paging in SQL servre 2008. I used ROW_NUMBER() in where clause to achieve ms sql paging.

How to use like Operator in Sql Stored procedure?

6 October 2016

In this article I will show you how to create Sql Server Stored procedure like, parameter implemented for it. Here I used nullable parameter (IsNull) and search the product using Like keyword.

Datediff Sql Compare two dates

5 September 2016

In this article, I will explain how to compare two dates and gets number of days using Datediff in SQL server.

Page 1 of 3