MSSQL Query Blog

Converting VARCHAR Type Date to dd.mm.yyyy in SQL Server

Converting VARCHAR Type Date to dd.mm.yyyy in SQL Server

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)...

Viewing the Size of Log Files in SQL Server

Viewing the Size of Log Files in SQL Server

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...

Listing Tables by Creation Date in SQL Server

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...

Listing All Collations Supported in SQL Server

Hello everyone. In this article, I will try to give information about listing all collations supported in SQL Server. In SQL Server you may want to list all supported collations in some cases. You can easily do this using the query below. SELECT name, COLLATIONPROPERTY(name, ‘CodePage’) AS Code_Page, description FROM...

Don`t copy text!