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

RECENT POSTS

  • PL/SQL Best Practices

    This article lists some important SQL Best Practices with examples.
  • 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).
  • SELECT Statement in SQL

    In this article, you will learn how to use a SQL SELECT statement with various options.
  • Get Specific Day Using getdate() Function

    In this blog, you will learn about the tricks of getdate() function.
  • 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.
  • Aggregate Function In SQL

    In this session, I will describe the Aggregate Function of SQL.
  • 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.
  • Create Stored Procedure In MySQL

    This blog defines how to create stored procedure in MySQL.
  • Create a Trigger in MYSQL

    This blog and SQL script explains how to create a trigger in MySQL.
  • Call Stored Procedure Inside Another Stored Procedure

    SQL query example, how to call a stored procedure inside another stored procedure in SQL Server.
  • 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.
  • How To Import CSV File Into SQL Server

    Learn how to import a csv file into a SQL Server using bulk import using SQL.
  • 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.
  • 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.
  • How To Call A SQL Function In C#

    Functions in SQL Server are code modules that can implement business logic and execute code.
  • 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.
  • 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.
  • Encrypt and Decrypt in SQL Server: Part 4

    In this article, we will encrypt plain text and decrypt encrypted text using the asymmetric key.
  • 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.
  • 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.
  • Encrypt and Decrypt in SQL Server: Part 1

    In this article, we will discuss Service Master Key, backup, restore and alter Service Master Key.
  • 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.
  • Procedure to Create a New Job in SQL Server 2008

    Learn how to create a new job task in SQL Server 2008.
  • SQL For Beginners

    In this video series, we will learn dive deep into the concept of Structured Query Language (SQL) from the very basics. This article is ideal for beginners who want to learn SQL from scratch.
  • Constraints in SQL Server

    In this article, you will learn about SQL Server constraints with examples.
  • View More