SQL Language
SQL Language
This section describes SQL statements and syntaxes.

RECENT POSTS

  • Dharmesh Singh

    Using Exists with Correlated Subqueries

    This code snipet is for Using Exists with Correlated Subqueries.
    Dharmesh Singh Apr 24, 2016
  • Jignesh Trivedi

    SQL Injection In Dynamic SQL

    In this article you will learn about SQL Injection in Dynamic SQL.
    Jignesh Trivedi Apr 17, 2016
  • Dharmesh Singh

    Getting Result of Dynamic SQL into a Variable for Sql-Server

    This code snippet is for Getting result of dynamic SQL into a variable for sql-server.
    Dharmesh Singh Apr 16, 2016
  • Pramod Thakur

    User Defined Function in SQL

    In this blog we learn basic functions of SQL.
    Pramod Thakur Mar 31, 2016
  • Ashish Srivastava

    Copy All tables with Data in Another Database

    This code snippet for how to Copy All tables with Data in Another Database.
    Ashish Srivastava Mar 22, 2016
  • Ashish Srivastava

    SQL Group With Group Total

    This code snippet for SQL Group With group Total.
    Ashish Srivastava Mar 22, 2016
  • Jainish Shah

    Top Keyword in SQL

    This blog is about the Top keyword in SQL and it's use.
    Jainish Shah Mar 19, 2016
  • Kaustubh

    Join 2 Tables on a Column with Differing Collations in SQL

    Sometimes there is a scenario where you need to join 2 sql tables with different collations. The code snippet below explains how to join 2 tables on a column with differing collations in SQL.
    Kaustubh Mar 12, 2016
  • Gaurav Gangwar

    How to Print Star Triangle in SQL Using CTE

    This code snippet for Print Pattern triangle in SQL.
    Gaurav Gangwar Jan 27, 2016
  • Gaurav Gangwar

    Convert Row Into Column in SQL

    This code snippet for Converting row into column using excel function.
    Gaurav Gangwar Jan 27, 2016
  • Jainish Shah

    SQL For Beginners - WHERE Clause

    This article will help you to learn the WHERE clause and expressions used with it.
    Jainish Shah Jan 08, 2016
  • Maruthi Palllamalli

    DataTableAdapter Design Technique Using DataSet

    In this article you will learn DataTableAdapter Design Technique using DataSet.
  • Jainish Shah

    SQL For Beginners - SELECT Statement

    This article will help you to learn about SELECT Statement in SQL.
    Jainish Shah Jan 05, 2016
  • Sandeep Kumar

    Write Query for Creating Stored

    In this code Snippet I am writing Query for Creating Stored procedure.
    Sandeep Kumar Jan 04, 2016
  • Sandeep Kumar

    Find nth Lowest Salary from TYable EmpDetails

    In this code Snippet I am writing Query for find nth lowest salary from table.
    Sandeep Kumar Jan 04, 2016
  • Sandeep Kumar

    Find nth Highest Salary from Table Employee

    In this Code Snippet I am writing Query for find nth highest salary from table.
    Sandeep Kumar Jan 04, 2016
  • Pankaj  Kumar Choudhary

    Types Of Keys In Database

    In this article you will learn about different types of keys in database.
  • Jainish Shah

    SQL For Beginners - Introduction

    This article will help you to learn SQL from scratch.
    Jainish Shah Jan 03, 2016
  • Ravi Patel

    SQL Server Identity Column

    This code snippet for retrieving the current inserted identity id from table.
    Ravi Patel Dec 30, 2015
  • Ashutosh Mund

    Parsing XML Data from SQL Database Column

    In this blog you will learn how to Parsing XML Data from SQL Database Column.
    Ashutosh Mund Nov 28, 2015
  • Sivaraman Dhamodaran

    Using the Multi-Line Table-Valued Function

    The video shows using the Multi-line function created in the Previous video
  • Sivaraman Dhamodaran

    Multi-Line table valued function

    This video explains creating multi-line table valued function which returns a table defined by the function itself.
  • Sivaraman Dhamodaran

    Using the In-Line Table-Valued Function

    This video shows how one can use the In-Line function that returns a table.
  • Sivaraman Dhamodaran

    Creating Simple Table-Valued Function

    This video shows creating a simple table-valued function in SQL Server 2005
  • Mukesh Kumar

    Remove Last Character from String in SQL

    Using this code, we can remove last char from string in SQL.
    Mukesh Kumar Nov 19, 2015
  • View More