The process we will do is to create the script of the key fields of a table, namely the Primary Key, Foreign Key and Index Key fields. Even though I don’t use it much, in SQL Server, in some cases, we may only need to create a script for the...
Hello everyone, In this article, I will provide information about text encryption and decryption in SQL Server. You can use this type of encryption for data security in SQL Server. The point you need to pay attention to here is that you will use the key when decoding the key...
Hello everyone, In this article, I will try to share information about searching words in all tables in SQL Server. In SQL Server, in some cases, we may want to find a word we want in all tables. You can easily do this using the procedure below. Note: It may...
Hello everyone, In this article, I will give you information about how to setup and run job in SQL Server. You can use the query below to learn about the installation and running of the jobs you have created in SQL Server. Our query will bring us many information such...
Hello everyone, In this article, I will talk about how to list updated tables in SQL Server. In SQL Server, in some cases, it may be desirable to know which tables have been updated. I will describe my transactions using the Northwind database. Let’s check if there is a change...
Hello everyone, In this article, I will talk about the use of the nested while loop in SQL Server. Using a nested while loop in SQL Server is the process of adding another loop inside a loop. The logic of the loop works as follows. The outermost loop returns first....
Hello everyone, In this article, I will tell you about the use of While loop in SQL Server. While loop in SQL Server is a construct that keeps a certain block in the loop by repeating. The loop continues to run until this condition is False. It is important to...
Hello everyone, In this article, I will give information about finding the installation date of the program in SQL Server. We may need to learn the installation date of our server in SQL Server. You can easily do this using the query below. SELECT createdate AS [SQL Server Install Date]...
