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

RECENT POSTS

  • Bikesh Srivastava

    Get last week date in sql

    Today i am going to explain how to get last week date in sql. Suppose i running any procedure and want select date range of last week on each excution,so in case use this type of sql query, this...
    Bikesh Srivastava Aug 24, 2016
  • Vandana  Blogs

    To Find Current Month Data With SQL Query

    To fetch current month data with the help of SQL Server.
    Vandana Blogs Aug 16, 2016
  • Vandana  Blogs

    To Find Previous Month Data With SQL Query

    To fetch previous month data with the help of SQL Server.
    Vandana Blogs Aug 16, 2016
  • Soumalya Das

    SQL Date Format in HH:MM AM/PM

    This query is used for getting time in SQL Server in HH:MM AM/PM format.
    Soumalya Das Aug 09, 2016
  • Chinmaya Dash

    Find Parent's parent through query

    Find Parent's parent through query.
    Chinmaya Dash Aug 08, 2016
  • Gaurav Gohel

    Triggers in SQL Server

    This blog shows us, how to create a trigger in SQL Server for the beginner level.
    Gaurav Gohel Aug 05, 2016
  • 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
  • View More