MSSQL Query Blog

Listing Tables Without Indexes in SQL Server

Hello to everyone, In this article, I will try to give information about listing tables that do not contain Index in SQL Server. In SQL Server, in some cases, you may want to list tables that do not contain an Index. You can easily do this using the code below....

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

Don`t copy text!