SQL Language
This section describes SQL statements and syntaxes.

RECENT POSTS

  • Emiliano Musso

    Retrieve Table List With Number of Rows

    This article shows a quick way to list tables with a number of rows in a database.
    Emiliano Musso Apr 22, 2015
  • Rahul Saxena

    SQL Server Return All Records If Search Text is Blank

    In this article we will learn how to return all records if the search text is blank.
    Rahul Saxena Apr 22, 2015
  • Kml Surani

    Creating a Dynamic Table In SQL Server

    This blog describes creating a dynamic table name and Alter Table of User Registration Form
    Kml Surani Apr 16, 2015
  • Rakesh Kalluri

    Rank Functions in SQL Server

    In this article we will learn how to use Rank Functions in SQL Server.
    Rakesh Kalluri Apr 10, 2015
  • Dhanasekar

    CTE in SQL Server

    In this article we will learn about Common Table Expressions (CTE) in SQL SERVER 2008.
    Dhanasekar Apr 09, 2015
  • Debendra Dash

    Binding Events in a Calender From DataBase

    In this blog we will learn Binding Events in a Calender From DataBase.
    Debendra Dash Apr 07, 2015
  • Priti Kumari

    SSRS Requirements in SQL Server

    This article explains something we sometimes need to do and maybe this will be helpful sometime.
    Priti Kumari Apr 06, 2015
  • Nitin

    Finding nth highest salary from a table

    In this blog we will see how to find the nth highest salary from a given table.
    Nitin Apr 03, 2015
  • Priti Kumari

    SSRS Miscellaneous

    This article explains how to remove a question mark (?) from a report viewer page number control.
    Priti Kumari Apr 02, 2015
  • Rakesh Kalluri

    Comparing Scope_identity (), @@identity and Ident_current

    In this article we will see the differences among scope_identity (), @@identity and ident_current.
    Rakesh Kalluri Apr 02, 2015
  • Rakesh Kalluri

    Merge Statement in SQL Server

    In this article we will learn how to use the Merge Statement in SQL Server.
    Rakesh Kalluri Apr 02, 2015
  • Nitin

    Finding Index on a table in SQL Server

    In this blog we will see how to find indexes on a table.
    Nitin Apr 02, 2015
  • Nitin

    How to Convert SQL Data to XML

    In this blog we will see how to convert SQL table data to XML using a SQL Query.
    Nitin Mar 31, 2015
  • Rahul Saxena

    Return Coma Separated Value From a Table

    This article shows how to return Coma Separated Values from a table in SQL Server.
    Rahul Saxena Mar 31, 2015
  • Pankaj  Kumar Choudhary

    Indexes in SQL Server

    In this article you will learn about indexes of SQL Server.
  • Shridhar Sharma

    Copy Table Data Across Databases

    In this section we will copy table data within the database or across two databases.
    Shridhar Sharma Mar 19, 2015
  • Khargesh Rajput

    Find Number of Occurrence of a Character is String in SQL

    This blog will show how to count number of Occurrence of any string in string in SQL.
    Khargesh Rajput Mar 03, 2015
  • Sivaraman Dhamodaran

    Executing Stored Proc With Parameters

    This video shows how do you execute a stored procedure from Management studio by passing the expected parameters
  • Shaili Dashora

    Alter Columns DataType Without Dropping Table in SQL

    In this article, I will explain how to alter a database table column without dropping the table with simple example.
    Shaili Dashora Mar 01, 2015
  • Khargesh Rajput

    Insert Multiple Records in Single Query ( Avoid Multiple Insert )

    In this blog you will learn how to Insert Multiple Records in Single Query.
    Khargesh Rajput Feb 25, 2015
  • Rahul Saxena

    Get All Stored Procedure Name From a SQL Server Data Base

    Here I am going to show how we can get a list of all stored procedure from a SQL Server Data Base using below Query:
    Rahul Saxena Feb 23, 2015
  • Rahul Saxena

    Find MAX & MIN Salary By Year

    How we can find MAX & MIN salary in a Table Group By Year.
    Rahul Saxena Feb 22, 2015
  • Shaili Dashora

    Merge Statement in SQL Server

    This article explains the Merge Statement in SQL Server.
    Shaili Dashora Feb 18, 2015
  • Rahul Saxena

    Swap 2 Column Values in SQL Sever

    This article shows how to swap 2 column values in SQL Sever.
    Rahul Saxena Feb 13, 2015
  • Piyush Pansuriya

    Get Current Financial Year Using SQL Query

    This blog show how to Get Current Financial Year Using SQL Query.
    Piyush Pansuriya Feb 12, 2015