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

RECENT POSTS

  • Dharmesh Singh

    Find Out Table and Function Used in Procedure

    Find Out Table and Function Used in Procedure
    Dharmesh Singh Jul 29, 2016
  • Vasanti

    Get exact string with SQL

    This query will give you exact records with case sensitive.
    Vasanti Jul 29, 2016
  • Pankaj  Kumar Choudhary

    Get Day of Week in SQL Server

    In this blog we learn how get day name of week for given date.
  • Gaurav Kumar

    How to find Nth highest and lowest salary in SQL

    How to find Nth highest and lowest salary in SQL.
    Gaurav Kumar Jul 19, 2016
  • Venkatesan Arasappan

    To Get all Tables in Oracle With count

    To get all Tables in Oracle With count.
  • 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 18, 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 Apr 01, 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
  • Devart

    Debug LINQ Easily - Execute LINQ Queries at Design-time with LINQ Insight

    Devart presents LINQ Insight - a powerful Visual Studio add-in which allows developers to execute LINQ queries right from the code at design time, thus making creating and debugging LINQ queries mu...
    Devart Feb 21, 2016
  • Praveen Moosad

    Basic SQL Queries Book Available Now

    Today, we are pleased to announce one more ebook to the collection of C# Corner free books library, Basic SQL Queries. Basic SQL Queries book is written by C# Corner authors Kamal Rawat & Akshay Pa...
    Praveen Moosad Feb 21, 2016
  • Devart

    Devart Released dbForge SQL Complete 5.0

    Devart released a new version of dbForge SQL Complete with SQL Refactoring, Code Highlighting and other new features.
    Devart Feb 21, 2016
  • Gaurav Gangwar

    Convert Row Into Column in SQL

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

    How to Print Star Triangle in SQL Using CTE

    This code snippet for Print Pattern triangle in SQL.
    Gaurav Gangwar Jan 28, 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 09, 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 06, 2016
  • Sandeep Kumar

    Write Query for Creating Stored

    In this code Snippet I am writing Query for Creating Stored procedure.
    Sandeep Kumar Jan 05, 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 05, 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 05, 2016
  • Jainish Shah

    SQL For Beginners - Introduction

    This article will help you to learn SQL from scratch.
    Jainish Shah Jan 04, 2016
  • View More