MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will provide information about listing all subfolders in the main folder in SQL Server. In SQL Server, in some cases, you may want to list all subfolders within the main folder. You can easily do this using the code below. DECLARE @Table TABLE...
Hello to everyone, In this article, I will give information about displaying the date of addition and modification of columns in the table in SQL Server. In SQL Server, in some cases, you may want to display the date of insertion and modification of columns in a table. You can...
Hello to everyone, In this article, I will try to give information about getting the directory and parent directory of the file in SQL Server. In SQL Server, in some cases you may want to get the directory and parent directory of the file. You can easily do this using...
Hello to everyone, In this article, I will try to give you information about running the function like a procedure in SQL Server. There are those among us who know, but since they do not tell such a subject, I will tell. You can do this easily using the code...
Hello to everyone, In this article, I will give information about the function that fixes the Turkish character problem in SQL Server. First of all, there are other solutions to this process. Please also research these methods before using functions. You may experience Turkish character problems in SQL Server in...
Hello to everyone, In this article, I will provide information about the phone formatting function in SQL Server. In SQL Server, in some cases, you may want to format and display phone numbers in order to make them more readable. You can easily do this by using the function below....
Hello to everyone, In this article, I will provide information about extracting the Schema list of all databases in SQL Server. In SQL Server, in some cases, you may want to extract the Schema list of all databases. You can easily do this using the code below. DECLARE @SQL NVARCHAR(MAX);...
Hello to everyone, In this article, I will provide information about the last time the database was backed up in SQL Server. In SQL Server, in some cases, you may want to know when the database was last backed up. You can easily do this using the code below., SELECT...