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 …
Read More »SQL 2017 In-Memory Table
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 …
Read More »How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle
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 …
Read More »The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it
In order to restore the backup of a database encrypted with TDE (Transparent Data Encryption) to another instance, we need to transfer the certificate …
Read More »TDE(Transparent Data Encryption) On SQL Server
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 …
Read More »SQL Server Loops and Conditions(TSQL)
In this article, we will examine the loops and conditions we use in TSQL. Conditions in TSQL: IF Statement in SQL Server: If the …
Read More »CASE Statement in SQL Server(TSQL)
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 …
Read More »While Loop in SQL Server(TSQL)
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 …
Read More »GOTO Statement in SQL Server(TSQL)
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/]
Read More »Break and Continue Statements in SQL Server(TSQL)
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 …
Read More »