MSSQL and TSQL Programming and TSQL Examples
Hello everyone. In this article, I will give information about converting Hijri date to Gregorian date in SQL Server. In SQL Server, in some cases, you may want to convert the Hijri date to the Gregorian date. You can easily do this using the code below. SELECT CONVERT(DATETIME, value, 131)...
Hello everyone. In this article, I will talk about the differences between EXISTS and NOT EXISTS in SQL Server. The differences between EXISTS and NOT EXISTS in SQL Server are as follows. In SQL Server, EXISTS and NOT EXISTS are two different operators used to test whether the condition specified...
Hello everyone, In this article I will share information about using CROSS APPLY in SQL Server In SQL Server, CROSS APPLY is a JOIN operator that allows you to apply data from one table or query to another table or query. CROSS APPLY, like OUTER APPLY, is one of the...
Hello everyone, In this article I will talk about the differences between Temporary Table and Table variable in SQL Server. The differences between Temporary Table and Table variable in SQL Server are as follows. The names of Temporary tables begin with the ‘#’ sign and are defined as a temporary...
Hello everyone, In this article, I will share information about using OUTER APPLY in SQL Server. In SQL Server, OUTER APPLY is a JOIN operator that allows you to apply data from one table or query to another table or query. OUTER APPLY, like CROSS APPLY, is one of the...
Hello everyone, In this article I will give information about Conversion failed when converting date and/or time from character string error in SQL Server. When you want to convert date in SQL Server, you may encounter the following error. You will get an error like the one above because the...
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 share information about the procedure for outputting tables in HTML format in SQL Server In SQL Server, in some cases you may want to output the tables in HTML format. You can easily do this by using the following procedure. CREATE PROCEDURE [dbo].[SqlTableToHtml]...