MSSQL and TSQL Programming and TSQL Examples
SQL Server Functions articles and Function code examples
Hello everyone. In this article, I will try to give information about the function that prints the initials of words side by side in SQL Server. In SQL Server, in some cases, you may want to print the initials of the words of a given sentence side by side. You...
Hello everyone, In this article, I will give information about URL parsing in SQL Server. In SQL Server you may want to parse the URL in some cases. Let me explain what I mean. Have a URL address like the one below. https://www.example.com/?utm_source=google&utm_medium=blabla&utm_campaign=gameuser&utm_term=winwin&utm_content=takego We will parse this URL address as...
Hello everyone, In this article, I will try to give information about the differences between the COUNT and COUNT_BIG functions in SQL Server. COUNT and COUNT_BIG are both aggregate functions in SQL Server that are used to count the number of rows in a table or a result set. The...
Hello everyone, In this article, I will try to give information about the function that performs credit card verification in SQL Server. In some cases, you may want to perform credit card authentication in SQL Server. You can easily do this using the function below. When you create and run...
Hello everyone, In this article, I will try to give information about the function that splits text containing comma-separated words in SQL Server. In SQL Server you may want to break up comma separated words in some cases. You can easily do this by creating and using the function below....
Hello everyone, In this article, I will try to give information about the function that makes the e-mail address compatible in SQL Server. In SQL Server, in some cases, Turkish characters may be entered in the e-mail addresses or it may be necessary to correct the e-mail addresses before entering...
Hello everyone, In this article, I will try to give information about the function that clears special characters in SQL Server. In SQL Server you may want to clear special characters in some cases. You can easily do this using the function below. CREATE FUNCTION fn_Ozel_Karakterleri_Temizle (@Temp VARCHAR(2000)) RETURNS VARCHAR(2000)...
Hello everybody, In this article, I will try to give information about the leap year control function in SQL Server. In SQL Server, in some cases, you may want to check for leap years. You can easily do this using the function below. CREATE FUNCTION dbo.IsLeapYear ( @year INT )...