SQL Language
This section describes SQL statements and syntaxes.

Blogs

  • 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
  • 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
  • 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 22, 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
  • 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
  • Shubham Kumar

    Delete all Duplicate Rows or Records From SQL Table

    In this blog you will learn how to Delete all Duplicate Rows or Records From SQL Table.
    Shubham Kumar Feb 08, 2015
  • Mukesh Kumar Tiwari

    Get Data From Database using Lambda Expression in SQL using NOT IN(Value,or list of value)

    In this blog you will learn how to Get Data From Database using Lambda Expression in SQL using NOT IN(Value,or list of value).
  • Pramod Thakur

    Case Statement in Update Command SQL Server

    In this blog we learn how to use case statement in update command.
    Pramod Thakur Jan 12, 2015
  • Pramod Thakur

    Delete Duplicate Record in SQL Server

    In this blog we learn how to delete duplicate record in sql server without using temp table.
    Pramod Thakur Jan 09, 2015
  • Pramod Thakur

    Find Nth Highest Salary using Dense_rank Function in SQL

    In this blog we learn how to find nth highest salary using Dense_Rank function is SQL.
    Pramod Thakur Jan 05, 2015
  • Pramod Thakur

    Find Maximum and Minimum salary by Department in SQL Server

    In this blog we learn how to get the maximum and minimum salary by department in SQL server.
    Pramod Thakur Dec 25, 2014
  • Hemant Srivastava

    Use Return Value from a Stored Procedure which Executed within Another Stored Procedure

    Here I am going to discuss how we could call a stored procedure within a stored procedure and then use the returned value from the executed stored procedure in the caller stored procedure.
    Hemant Srivastava Dec 22, 2014
  • N Vinodh

    Insert Data into Database using Simple Stored Procedure in SQL

    This blog describe how to Insert Data into Database using Simple Stored Procedure in SQL.
    N Vinodh Dec 03, 2014
  • Rakesh Kalluri

    Difference between Delete and Truncate in SQL Query

    This blog describes the difference between Delete and Truncate in a SQL query.
    Rakesh Kalluri Dec 03, 2014
  • Vishvajeet Pawar

    Join Table Value Function with Table in SQL

    In this blog I will show you how to Join Table Valued Function with Table in SQL.
    Vishvajeet Pawar Nov 24, 2014
  • Vishvajeet Pawar

    Reset Identity Column In SQL

    In this blog, I will show How to Reset Identity Column in SQL?
    Vishvajeet Pawar Nov 17, 2014
  • Gaurav Kumar

    Get Data from SQL Server without Null Values

    This blog describe how to Get Data from SQL Server without Null Values.
    Gaurav Kumar Nov 11, 2014
  • Rakesh Kalluri

    WAITFOR query in SQL

    In this blog you will learn how to use WAITFOR query in SQL.
    Rakesh Kalluri Nov 04, 2014