SQL
Learn SQL, a language to query and manipulate relational database management systems.

RECENT POSTS

  • Sarvesh Shinde

    Iterate Through Array Of Data In SQL Query

    In this article we will see how to create a Array variable in SQL and how to iterate through it to process records in database.
    Sarvesh Shinde Jan 23, 2020
  • Naresh Beniwal

    SQL Index statement

    In this article, you will learn how to create an Index statement in SQL.
    Naresh Beniwal Jan 15, 2020
  • Naresh Beniwal

    SQL 'Is Null' Statement Explained

    This blog explains the use of the SQL 'Is Null' statement.
    Naresh Beniwal Jan 13, 2020
  • Subal Mishra

    PL/SQL Best Practices

    This article lists some important SQL Best Practices with examples.
    Subal Mishra Oct 09, 2019
  • Kuldeep Singh

    SQL Change Automation 4.0 Released

    SQL Change Automation 4.0 allows you to develop database changes in either Visual Studio or Microsoft SQL Server Management Studio (SSMS).
    Kuldeep Singh Sep 19, 2019
  • Naresh Beniwal

    SELECT Statement in SQL

    In this article, you will learn how to use a SQL SELECT statement with various options.
    Naresh Beniwal Sep 19, 2019
  • Christian Ashish

    Get Specific Day Using getdate() Function

    In this blog, you will learn about the tricks of getdate() function.
    Christian Ashish Sep 17, 2019
  • Sonu Gupta

    Top 5 Tricky/Important SQL Queries And Their Answers

    In this article, you will learn about SQL Server Top 5 tricky/ important SQL Query with their answers.
    Sonu Gupta Sep 05, 2019
  • Bidyasagar Mishra

    Aggregate Function In SQL

    In this session, I will describe the Aggregate Function of SQL.
    Bidyasagar Mishra Sep 05, 2019
  • Jignesh Trivedi

    Use Of Table-Valued Parameter In SQL Server

    Learn what is a Table Valued Parameter in SQL Server and how to create and use table valued parameters in stored procedures and queries.
    Jignesh Trivedi Aug 26, 2019
  • Pankaj Pandey

    Create Stored Procedure In MySQL

    This blog defines how to create stored procedure in MySQL.
    Pankaj Pandey Aug 26, 2019
  • Pankaj Pandey

    Create a Trigger in MYSQL

    This blog and SQL script explains how to create a trigger in MySQL.
    Pankaj Pandey Aug 26, 2019
  • Pankaj Pandey

    Call Stored Procedure Inside Another Stored Procedure

    SQL query example, how to call a stored procedure inside another stored procedure in SQL Server.
    Pankaj Pandey Aug 22, 2019
  • Gowtham K

    Executing SQL Stored Procedure from Another Stored Procedure

    In this blog, I explain how to execute a stored procedure within another stored procedure in SQL with parameters.
    Gowtham K Aug 22, 2019
  • Pankaj Pandey

    How To Import CSV File Into SQL Server

    Learn how to import a csv file into a SQL Server using bulk import using SQL.
    Pankaj Pandey Aug 22, 2019
  • Pankaj Pandey

    SQL Query To Copy All Data From A Table Into A New Table

    Here are the steps required to copy data from a database table into a new table using SQL.
    Pankaj Pandey Aug 22, 2019
  • Jignesh Trivedi

    What Is SQL Common Table Expression (CTE)

    Common Table Expression in SQL Server offers a more readable form of the derived table, which can be declared once and referenced multiple times in a query.
    Jignesh Trivedi Aug 21, 2019
  • Pankaj Pandey

    How To Call A SQL Function In C#

    Functions in SQL Server are code modules that can implement business logic and execute code.
    Pankaj Pandey Aug 20, 2019
  • Bidyasagar Mishra

    Role Of SQL Like And Wildcards

    In this session, I will discuss SQL Like and wildcard characters in SQL Like. I will also discuss why and how to use in SQL queries.
    Bidyasagar Mishra Aug 20, 2019
  • Akshay Patel

    Encrypt and Decrypt in SQL Server: Part 5

    In this article, we will create a symmetric key and encrypt and decrypt string using this key.
    Akshay Patel Aug 19, 2019
  • Akshay Patel

    Encrypt and Decrypt in SQL Server: Part 4

    In this article, we will encrypt plain text and decrypt encrypted text using the asymmetric key.
    Akshay Patel Aug 19, 2019
  • Akshay Patel

    Encrypt and Decrypt in SQL Server: Part 3

    In this article, we will generate a certificate and using this certificate we will encrypt and decrypt the string.
    Akshay Patel Aug 19, 2019
  • Akshay Patel

    Encrypt and Decrypt in SQL Server: Part 2

    In this article, we will discuss Database Master Key. The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database.
    Akshay Patel Aug 19, 2019
  • Akshay Patel

    Encrypt and Decrypt in SQL Server: Part 1

    In this article, we will discuss Service Master Key, backup, restore and alter Service Master Key.
    Akshay Patel Aug 19, 2019
  • Raj Kumar

    Create and Schedule a Job in SQL Server

    In this article you will learn how to create a new job and schedule that job for execution in SQL Server 2008.
    Raj Kumar Aug 15, 2019
  • View More