MSSQL and TSQL Programming and TSQL Examples
Hello everyone. In this article, I will try to give information about listing the largest tables and indexes in the database in SQL Server. In SQL Server, in some cases you may want to list the largest tables and Indexes in the database. You can easily do this using the...
Hello everyone. In this article, I will try to give information about the function that prints the initials of words side by side in SQL Server. In SQL Server, in some cases, you may want to print the initials of the words of a given sentence side by side. You...
Hello everyone. In this article, I will try to give information about getting the second word in the sentence given in SQL Server. In SQL Server you may want to get the second word in the given sentence in some cases. You can easily do this using the code below....
Hello everyone. In this article, I will try to give information about converting VARCHAR type date as dd.mm.yyyy in SQL Server. In SQL Server, in some cases, you may want to convert the VARCHAR type date to dd.mm.yyyy. You can easily do this using the code below. DECLARE @tarih VARCHAR(30)...
Hello everyone. In this article, I will try to give information about the procedure that creates Property from Tables and Views in SQL Server. If you’re programming on the CSharp side, you need Properties. It can take a lot of time to create a table or view and then create...
Hello everyone, In this article, I will provide information about viewing the size of log files in SQL Server. In SQL Server we may want to view the size of log files in some cases. You can easily do this with the help of the code below. SELECT DB_NAME(mf.database_id) AS...
Hello everyone. In this article, I will try to give information about listing tables by creation date in SQL Server. In SQL Server, in some cases you may want to list tables by creation date. You can easily do this using the code below. SELECT name ,create_date FROM sys.tables ORDER...
Hello everyone. In this article, I will try to give information about the customized PRINT procedure in SQL Server. In SQL Server, the PRINT statement prints up to 4000 characters. So what will you do if the content of the dynamic queries you write is longer than 4000 characters? In...