Author: Yavuz Selim Kart

Listing All Days of a Year in SQL Server

Hello to everyone, In this article, I will try to give information about listing all the days of a year in SQL Server. In SQL Server, in some cases you may want to list all the days of a year. You can easily do this using the code below. WITH...

Getting the Millisecond Value in SQL Server

Hello to everyone, In this article, I will try to give information about obtaining the millisecond value in SQL Server. In SQL Server, you may want to get the Milliseconds value in some cases. You can easily do this using the code below. SELECT (DATEPART(MILLISECOND, GETDATE())); When you run the...

Listing Online and Offline Databases in SQL Server

Hello to everyone, In this article, I will try to give information about listing online and offline databases in SQL Server. In SQL Server, in some cases, you may want to list online and offline databases. You can easily do this using the code below. –Offline Databases SELECT * FROM...

Don`t copy text!