MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about listing when Full, Differential and Log backups of all databases are taken in SQL Server. In SQL Server, in some cases, you may want to list when Full, Differential and Log backups of all databases were taken. You...
Hello everyone, In this article, I will try to give information about which database uses how much RAM in SQL Server. In SQL Server, you may want to know how much RAM each database uses in some cases. You can easily do this using the code below. SELECT [DatabaseName] =...
Hello everyone, In this article, I will talk about how to display long query lines in SQL Server to fit the Query screen. For this process. in SQL Server Tools Options Text Editor All Languages We put a tick on Settings -> Word Wrap. When you perform the operations in...
Hello everyone, In this article, I will try to give information about the function that makes the e-mail address compatible in SQL Server. In SQL Server, in some cases, Turkish characters may be entered in the e-mail addresses or it may be necessary to correct the e-mail addresses before entering...
Hello everyone, In this article, I will try to give information about querying the Identity columns of all tables in SQL Server. In SQL Server, in some cases, you may want to query the Identity columns of all tables, ie list them. You can easily do this using the code...
Hello everyone, In this article, I will try to give information about running large SQL Scripts in SQL Server. In SQL Server, in some cases, you may want to run SQL scripts that consist of too many queries, but in this case, you may also get an error. You can...
Hello everyone, In this article, I will provide information on how to write a cursor that changes the schema name in SQL Server. While researching in SQL Server I was wondering how to change all schema names in one go. You can see the sample code for this below. Just...
Hello everyone, In this article, I will try to give information about the function that clears special characters in SQL Server. In SQL Server you may want to clear special characters in some cases. You can easily do this using the function below. CREATE FUNCTION fn_Ozel_Karakterleri_Temizle (@Temp VARCHAR(2000)) RETURNS VARCHAR(2000)...