MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will give information about the function that clears non-numeric characters in SQL Server. In SQL Server, in some cases, we may want to remove parentheses, dashes, etc. on a numeric text. You can easily do this with the help of the function below. ...
Hello to everyone, In this article, I will try to give you information about running the function like a procedure in SQL Server. There are those among us who know, but since they do not tell such a subject, I will tell. You can do this easily using the code...
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...
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....
Hello to everyone, In this article, I will try to give information about the function that checks the prime number in SQL Server. In SQL Server, in some cases, you may want to check if the number you have is a prime number. You can easily do this using the...
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...
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...
Hello to everyone, In this article, I will try to give information about the use of the function that converts JSON Data to XML in SQL Server. In SQL Server, in some cases you may need to convert your JSON data to XML. You can easily do this using the...