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.

In this article, you will learn how to create an Index statement in SQL.

This blog explains the use of the SQL 'Is Null' statement.

This article lists some important SQL Best Practices with examples.

SQL Change Automation 4.0 allows you to develop database changes in either Visual Studio or Microsoft SQL Server Management Studio (SSMS).

In this article, you will learn how to use a SQL SELECT statement with various options.

In this blog, you will learn about the tricks of getdate() function.

In this article, you will learn about SQL Server Top 5 tricky/ important SQL Query with their answers.

In this session, I will describe the Aggregate Function of SQL.

Learn what is a Table Valued Parameter in SQL Server and how to create and use table valued parameters in stored procedures and queries.

This blog defines how to create stored procedure in MySQL.

This blog and SQL script explains how to create a trigger in MySQL.

SQL query example, how to call a stored procedure inside another stored procedure in SQL Server.

In this blog, I explain how to execute a stored procedure within another stored procedure in SQL with parameters.

Learn how to import a csv file into a SQL Server using bulk import using SQL.

Here are the steps required to copy data from a database table into a new table using SQL.

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.

Functions in SQL Server are code modules that can implement business logic and execute code.

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.

In this article, we will create a symmetric key and encrypt and decrypt string using this key.

In this article, we will encrypt plain text and decrypt encrypted text using the asymmetric key.

In this article, we will generate a certificate and using this certificate we will encrypt and decrypt the string.

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.

In this article, we will discuss Service Master Key, backup, restore and alter Service Master Key.

In this article you will learn how to create a new job and schedule that job for execution in SQL Server 2008.