MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will talk about the difference between stored procedures and functions in SQL Server. Stored procedures are sql statements that are stored by the database and do not need to be recompiled after the first compilation. Functions are sql codes that can return any...
Hello to everyone, In this article, I will try to give information about the function that displays the difference between dates as days, hours, minutes and seconds in SQL Server. In SQL Server, in some cases, you may want to display the difference between dates in days, hours, minutes, and...
Hello everyone, In this article, I will try to give information about writing a WordWrap function in SQL Server. In SQL Server you may need a function like WordWrap in some cases. WordWrap cuts a text to a certain length and displays the remainder on a new line. This is...
Hello everyone, In this article, I will try to give information about the function that checks mail in SQL Server. In some cases, you may want to check the e-mail address you have in SQL Server. You can easily do this using the function below. CREATE FUNCTION fn_eMailKontrol ( @EmailAddr...
Hello everyone, In this article, I will give information about the equivalent of the Oracle LAST_DAY() function in SQL Server. In SQL Server, in some cases, we may want to see and use functions that are in other databases. What is the LAST_DAY() function? The LAST_DAY() function returns the date...
Hello everyone, In this article, I will try to give information about the function that converts Integer data to date in SQL Server. In SQL Server, in some cases, you may want to convert Integer data to date. You can easily do this using the function below. CREATE FUNCTION INTtoDATE...
Hello everyone, In this article, I will give information about writing the Oracle NEXT_DAY function in SQL Server. In SQL Server, in some cases, we may want to see and use functions that exist in other databases. What is the NEXT_DAY function? The NEXT_DAY function has 2 parameters. The first...
Hello to everyone, In this article, I will try to give information about the function that encodes text to Base64 in SQL Server. In SQL Server, in some cases, you may want to encode text to Base64. You can easily do this using the code below. CREATE FUNCTION [dbo].[fnBase64Encode] (...