MSSQL Query Blog

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

Listing Index Dimensions of Tables in SQL Server

Hello to everyone, In this article, I will try to give information about listing the Index dimensions of tables in SQL Server. In SQL Server, in some cases you may want to list the Index dimensions of the tables. You can easily do this using the code below. SELECT sys_schemas.name...

Don`t copy text!