Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

We can use the SQL EXCEPT Operator between two SQL Statement. It allows us to return records that exist in the first SQL Statement, but …

Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this …

  Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has managed instances on the basis of server pools for the effective use …

  In order to restore the backup of a database encrypted with TDE (Transparent Data Encryption) to another instance, we need to transfer the certificate …

TDE is used to encrypt the database. With TDE, Data and Log files are encrypted at the page level in real time and there is …

  In this article, we will examine the loops and conditions we use in TSQL. Conditions in TSQL: IF Statement in SQL Server: If the …

Certain conditions are checked with the WHEN Statement when using the CASE Statement, and certain results are returned if the condition is met. We can …

By creating a loop, we can perform certain operations as long as this loop continues. We can use While Loop as follows. As long as …

If a specific condition occurs, you can use the GOTO statement to run the code in a given label. The use is as follows. [crayon-688a9e3741dc8467999105/]

  BREAK Statement: You may want to terminate while loop by using the BREAK statement. You can use it as follows. [crayon-688a9e374200f754677252/] Continue Statement: Usually …