MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will talk about time format changing operations in SQL Server. Time format change is often used in SQL Server. You can use the codes below to change the time format. 8 SELECT CONVERT(VARCHAR, GETDATE(), 8); hh:mm:ss 00:38:54 14 SELECT CONVERT(VARCHAR, GETDATE(), 14); hh:mm:ss:nnn...
Hello to everyone, In this article, I will give information about the COUNT function and NULL values in SQL Server. Let me briefly explain what I mean by the COUNT function and NULL values. As you know, the COUNT function gives the total number of records in the specified field...
Hello to everyone, In this article, I will try to give information about the function that shows whitespace in SQL Server. There may be a need for whitespace detection in SQL Server in some cases. First, let’s learn what whitespace is. Contrary to popular belief, its meaning is not just...
Hello to everyone, In this article, I will try to give you information about calling a procedure from within a function in SQL Server. Many of you started reading the article saying that such a thing would not happen, or you started reading the article wondering how it really is....
Hello to everyone, In this article, I will try to give information about the function that calculates the working days between two dates in SQL Server. If you are calculating the working days of the staff in SQL Server, you may need such a function. I wrote it simply. You...
Hello to everyone, In this article, I will give information about the function that brings seasonal information in SQL Server. In SQL Server you may want to fetch seasonal information in some cases. You can easily do this with the help of the function below. CREATE FUNCTION getSeasonInformation ( @Date...
Hello to everyone, In this article I will talk about how to find leap years in SQL Server. You can read my previous article on the subject at the link below. According to the comment made by Barak G. on the Linkedin platform, I revised the leap year check function....
Hello to everyone, In this article I will talk about how to find leap years in SQL Server. Leap years are years where an extra, or intercalary, day is added to the end of the shortest month, February. The intercalary day, February 29, is commonly referred to as leap day....