Category: Functions

Function to Fix Turkish Character Problem in SQL Server

Hello to everyone, In this article, I will give information about the function that fixes the Turkish character problem in SQL Server. First of all, there are other solutions to this process. Please also research these methods before using functions. You may experience Turkish character problems in SQL Server in...

Phone Formatting Function in SQL Server

Hello to everyone, In this article, I will provide information about the phone formatting function in SQL Server. In SQL Server, in some cases, you may want to format and display phone numbers in order to make them more readable. You can easily do this by using the function below....

Listing All Functions in SQL Server

Hello to everyone, In this article, I will give information about how to list all functions in SQL Server. In SQL Server you may want to list all functions in some cases. You can do this easily with the help of the code below. SELECT name, definition, type_desc FROM sys.sql_modules...

SQL Server Date Formats

Hello to everyone, In this article, I will talk about Date format change operations in SQL Server. Date format change is often used in SQL Server. You can use the codes below to change the date format. 1 SELECT CONVERT(VARCHAR, GETDATE(), 1); mm/dd/yy 12/30/06 2 SELECT CONVERT(VARCHAR, GETDATE(), 2); yy.mm.dd...

Don`t copy text!