SQL Language
This section describes SQL statements and syntaxes.

Links

  • Ankur Mistry

    PostgreSQL - Open Source Database

    PostgreSQL is most advanced open source database.
    Ankur Mistry Oct 04, 2017
  • Michał Jankowski

    SQL Unit Tests - Coverage Report

    Article shows how to generate test cover report for SQL.
    Michał Jankowski Sep 13, 2016
  • Subash

    Difference Between DDL, DML, DCL?

    Know about difference between DDL, DML, DCL by clicking on the link provided.
    Subash Aug 01, 2016
  • Bala

    Table value parameter with Example in SQL

    Here the best article about the table value parameter in sql server 2008. This TVP is new features in SQL SERVER 2008 version, which is not available in earlier one.
    Bala Jun 25, 2013
  • Bineesh  VP

    SQL Interview Questions

    You can find 65 SQL Server Questions and Answers. This makes you a step ahead from the SQL beginner stage.
    Bineesh VP Jun 14, 2013
  • Kumar Sambhav

    Encrypting a Column in SQL Server

    Encrypt data so that even if somebody was able to reach to data it is not discernible by a simple query.
    Kumar Sambhav May 23, 2013
  • Kumar Sambhav

    Display Line Numbers in a SQL Server Management Studio Query Window

    Often we see an error message from SQL Server which references a particular line number within our T-SQL code. It is a little frustrating to find the line number where the syntax error has occurred.
    Kumar Sambhav May 21, 2013
  • Senthil Nathan

    SQL Queries Interview Questions and answers

    Frequently asked basic and advanced Top 75 + Database SQL Interview Questions and Answers with Examples, Queries for Freshers and Experienced Java, PHP, .Net Developers in Oracle, MySQL and SQL Ser...
    Senthil Nathan May 15, 2013
  • Pradip Pandey

    Database development approach that fits into agile development methodology

    Agile development methodology is most popular among the developers. We can also get the advantage of this technology when creating and maintaining a database in SQL Server.
    Pradip Pandey Mar 05, 2013
  • Pradip Pandey

    Best practices of SQL Server performance monitor

    Performance monitor is not only for SQL Server but also for Windows itself, file & print servers etc.
    Pradip Pandey Feb 15, 2013
  • Pradip Pandey

    Generate a set or sequence without loop

    Generate a set or sequence without loop
    Pradip Pandey Jan 21, 2013
  • Pradip Pandey

    Custom metric in SQL Server

    This article will help the users who are facing problems from internal, SQL Server, memory issues, or external, Windows OS, memory issues directly.
    Pradip Pandey Jan 16, 2013
  • Akkiraju Ivaturi

    Why tSQLt

    This is set to change with the arrival of test frameworks that use SQL, and a plug-in for SQL Server Management Studio. Greg Lucas explains why.
    Akkiraju Ivaturi Sep 07, 2012
  • Sukesh Marla
  • Sukesh Marla

    Best way to count number of records in a table using SQL

    Which is the best way to count number of records in a table.
    Sukesh Marla Sep 03, 2012
  • Akkiraju Ivaturi

    Dynamic SQL - SQL Server Vs MySQL?

    Author discusses on Dynamic SQL across SQL Server and MySQL.
    Akkiraju Ivaturi Aug 29, 2012
  • Amit Patel
  • X

    Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

    Start Learning Now