MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will give information about what are the Differences Between Function and Procedure in SQL Server. This question especially comes to mind of curious friends who are just learning SQL Server. This question may come up in job interviews. It is useful to know briefly,...
Hello everyone, In this article, I will give information about the difference between Count and Count_Big functions in SQL Server. There is no difference in functionality between Count and Count_Big. They are almost the same. The only difference is the data type they return and the indexing on the view....
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) =...
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...
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...
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...
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],...
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....