MSSQL and TSQL Programming and TSQL Examples
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...
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 how to list All Triggers in SQL Server. In SQL Server you may want to list all Triggers in some cases. You can do this easily with the help of the code below. SELECT name AS TriggerName, is_disabled AS...
Hello to everyone, In this article I will share the list of SQL Server versions. Release RTM (Gold, no SP) Latest CU SQL Server 2019 SQL Server latest version SQL Server 15 SQL Server 15.0 codename Aris Seattle Support end date: 2025-01-07 Ext. end date: 2030-01-08 15.0.2000.5 15.00.2000.5 CU13 (15.0.4178.1, October...
Hello to everyone, In this article, I will give information about how to list All Jobs in SQL Server. In SQL Server you may want to list all Jobs in some cases. You can do this easily with the help of the code below. –Listing All Jobs in SQL Server...
Hello to everyone, In this article I will provide information on how to list All Views in SQL Server. In SQL Server you may want to list all Views in some cases. You can easily do this with the help of the code below. –Listing All Views in SQL Server...
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...