SQL Language
This section describes SQL statements and syntaxes.

RECENT POSTS

  • 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

    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 Multi-Line Table-Valued Function

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

    Creating Simple Table-Valued Function

    This video shows creating a simple table-valued function in SQL Server 2005
  • 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

    Creating Simple Function

    This video explains creating a simple User-Defined function in SQL Server 2005.
  • Kailash Chandra Behera

    SQL Transaction Overview

    This article describes about Sql transaction with example in SQL language as well as ADO.NET.
  • SANTHOSH KUMAR

    SQL Basics Overview

    In this article you will learn about SQL basics.
    SANTHOSH KUMAR Oct 24, 2015
  • Pankaj  Kumar Choudhary

    SQL Basic Queries

    In this article I will explain some basic SQL queries.
  • Gowtham K

    Convert Data Table to XML in SQL Server

    From this blog we will learn how to convert the data table to XML using XML Raw, XML path, XML Auto.
    Gowtham K Aug 30, 2015
  • Amol Jadhao

    Difference between Output Parameter and Return Value in Stored Procedure

    This article will help you to understand the difference between output parameter and return value in a Stored Procedure.
    Amol Jadhao Aug 26, 2015
  • Deepak Kumar Choudhary

    Introducing Trigger

    In this blog you will learn about Trigger.
  • Gowtham K

    Calling/Executing SQL Stored Procedure from Another Stored Procedure

    In this blog I will explain one of the major application in stored procedure that is executing/calling one procedure from another procedure with parameters.
    Gowtham K Aug 19, 2015
  • Jitendra Kumar

    Some Simple and Important SQL Server Query Based Interview Questions

    In this article I explain some important SQL query qustions that are commonly asked when you go for an interview for a position requiring one to three years of experience in this field.
    Jitendra Kumar Aug 04, 2015
  • Rakesh Kalluri

    Difference Between Grouping and Grouping_ID in SQL

    In this article you will learn the difference between Grouping and Grouping_ID in SQL Server.
    Rakesh Kalluri Jul 31, 2015
  • Priti Kumari

    Numeric Field Validation in SSRS

    In this article we will learn how to validate a numeric parameter value. In the previous article you saw how to validate a date parameter SSRS parameter validation using custom code.
    Priti Kumari Jul 24, 2015
  • Rahul Saxena

    Show Date and Time in a Formatted Manner in SQL Server

    This article shows how to show a date and time in a formatted manner as per our business requirements.
    Rahul Saxena Jul 22, 2015
  • Rakesh Kalluri

    Restrict SP_ (Naming convention) using DDL Trigger

    In this blog you will learn about Restrict SP_ (Naming convention) using DDL Trigger.
    Rakesh Kalluri Jul 21, 2015
  • Rakesh Kalluri

    Filtering Data With TOP Option in SQL

    In this article you will learn how to filter data with TOP in SQL.
    Rakesh Kalluri Jul 18, 2015
  • Govinda Rajulu Yemineni

    SET vs. SELECT when assigning values to variables

    In this blog we will see the difference between SET and SELECT while assigning values to variables.
  • Rakesh Kalluri

    Difference between COUNT and COUNT_BIG in SQL

    In this blog you will learn Difference between COUNT and COUNT_BIG in SQL.
    Rakesh Kalluri Jul 13, 2015
  • Pankaj  Kumar Choudhary

    SQL Table in Android

    This article explains how to create a SQL table and how to insert, delete and retrieve data from a SQL table in Android.
  • Animesh Datta

    Get Monthly Attendance Report by Stored Procedure in SQL

    This article explains how to get a monthly attendance report using a Stored Procedure in SQL.
    Animesh Datta Jul 08, 2015
  • Suraj Sahoo

    Full Text Search in SQL

    This article shows how to create a Full Text Search in SQL.
    Suraj Sahoo Jul 06, 2015
  • Rakesh Kalluri

    Foreign Key with Delete CASCADE in SQL

    in this blog you will learn Foreign Key with Delete CASCADE in SQL.
    Rakesh Kalluri Jul 06, 2015