MSSQL and TSQL Programming and TSQL Examples
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]...
Hello everyone, In this article, I will provide information about finding the database restoration date in SQL Server. We may need to find the date the database was restored in SQL Server. You can easily do this using the query below. USE msdb; SELECT DBRestored = destination_database_name, RestoreDate = restore_date,...
Hello everyone, In this article, I will give information about accessing the source code of the website in SQL Server. In SQL Server, in some cases, we may want to access the source codes of the website with T-SQL codes. First, you need to run the codes below and make...
Hello everyone, In this article, I will provide information about listing the most recently executed queries in SQL Server. In SQL Server, in some cases, we may want to see the last queries we ran. You can get information about the most recently run queries using the query below. SELECT...
Hello everyone, In this article, I will provide information about copying files in SQL Server. In some cases, it may be necessary to copy files in SQL Server. You can perform the copy operation using the code below. As an example, I created a text file named copy into the...
Hello everyone, In this article, I will give information about date formatting in SQL Server. In SQL Server, in some cases, we may want to format the date as we want. You can do this easily with the help of the codes below. SELECT CONVERT(VARCHAR, GETDATE(), 1); SELECT CONVERT(VARCHAR, GETDATE(),...
Hello everyone, In this article, I will give information about finding the number of words in a sentence in SQL Server. In SQL Server, in some cases, we may want to find the number of words in the sentence. You can easily do this with the help of the codes...