SQL Language
This section describes SQL statements and syntaxes.

RECENT POSTS

  • Jignesh Trivedi

    Get Months Within a Date Range With SQL Query

    This article shows how to get the months within a date range with SQL Query.
    Jignesh Trivedi Feb 11, 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 09, 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).
  • Prashant Shinde

    Basics of SQL Trigger

    In this article we will discuss basics of SQL Triggers and its types.
    Prashant Shinde Jan 20, 2015
  • Subal Mishra

    PL/SQL Best Practices

    In an enterprise data-driven application, the quality of SQL statements plays a vital role in an application's performance. A bad SQL statement can break the application. In this article, I discuss...
    Subal Mishra Jan 16, 2015
  • 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 16, 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 10, 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
  • Shubham Kumar

    How to Make EMI For Loan in SQL Server

    In this article you will learn how to make Equated Monthly Installments (EMIs) for a loan in SQL Server.
    Shubham Kumar Dec 29, 2014
  • 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
  • Rahul Saxena

    Show SQL Server Data Table in a XML Using SQL Query

    In this article I explain how to show our SQL Server data table in a XML format using SQL Query.
    Rahul Saxena Dec 09, 2014
  • Rakesh Kalluri

    Difference Between LEN and DATALENGTH Function in SQL

    This blog describe the difference between LEN and DATALENGTH function in SQL database.
    Rakesh Kalluri Dec 04, 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
  • 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
  • Jasminder Singh

    @@ Identity Vs ScopeIdentity Vs Ident_Current in SQL

    This article explains @@Identity, Scope_Identity() & Ident_Current('Table_Name') in SQL.
    Jasminder Singh Nov 29, 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
  • Teddy  Kurian

    Useful Commands in SQL

    Here I will describe some useful commands in SQL.
    Teddy Kurian Nov 20, 2014
  • Sums Mohs Eds

    Cursors vs Sets in SQL

    In this article, we have tried to help the developers choose whether to use cursors or sets.
    Sums Mohs Eds Nov 20, 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
  • Joginder Banger

    Get a Character, Numeric or Special Character String Value in SQL Server

    In this article you will learn how to get a character, numeric or special character string value in SQL server.
    Joginder Banger Nov 13, 2014
  • Jasminder Singh

    Inserted and Deleted Tables in SQL

    In this article, we will discuss the concept of Inserted and Deleted tables in SQL.
    Jasminder Singh Nov 12, 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
  • Anil Kumar

    Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements

    Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
    Anil Kumar Nov 07, 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