MSSQL Query Blog

5 March 2022

Simple Interest Calculation Function in SQL Server

Hello everyone, In this article, I will try to give information about the simple interest calculation function in SQL Server. In SQL Server, in some cases, you may want to calculate interest simply. You can easily do this using the function below. CREATE FUNCTION dbo.SimpleInterestFunction ( @Principal DECIMAL(18, 2) =...

SQL Server

5 March 2022

Converting Empty Value to Datetime in SQL Server

Hello everyone, In this article, I will try to give information about converting empty value to Datetime in SQL Server. In SQL Server, in some cases, you may want to convert an empty value to Datetime. You can easily do this using the code below. SELECT CAST(” AS DATE); When...

SQL Server / Triggers

3 March 2022

Trigger Preventing Table Creation in SQL Server

Hello everyone, In this article, I will provide information about creating triggers that prevent table creation in SQL Server. In SQL Server, in some cases, we may not want a table to be created in the current database. You can easily do this using the code below. CREATE TRIGGER StopTableCreation...

SQL Server / Triggers

1 March 2022

Getting List of Disabled or Enabled Triggers in Database in SQL Server

Hello everyone, In this article, I will provide information about getting the list of disabled or active Triggers in the database in SQL Server. In SQL Server, in some cases you may want to get the list of disabled or active Triggers. You can easily do this using the code...

SQL Server / Stored Procedures

1 March 2022

Finding Last Used Stored Procedure in SQL Server

Hello everyone, In this article, I will try to give information about finding the last used Stored Procedure in SQL Server. In SQL Server in some cases you may want to find the last used Stored Procedure. You can easily do this using the script below. SELECT DB_NAME(qt.[dbid]) AS [DatabaseName],...

SQL Server

28 February 2022

Finding the Last Restore Date of a Backup in SQL Server

Hello everyone, In this article, I will try to give information about finding the last restore date of a backup in SQL Server. In SQL Server, in some cases you may want to find the last restore date of the backup. You can easily do this using the code below....

SQL Server

28 February 2022

Listing All Time Zones in SQL Server

Hello everyone, In this article, I will try to give information about listing all time zones in SQL Server. In SQL Server you may want to list all time zones in some cases. You can easily do this using the code below. SELECT * FROM sys.time_zone_info When you run the...

SQL Server

28 February 2022

Most Used Database Files in SQL Server

Hello everyone, In this article, I will try to give information about finding the most used database files in SQL Server. In SQL Server, in some cases you may want to find the most used database files. You can easily do this by using the script below. SELECT DB_NAME(DbId) ‘Database...