MSSQL Query Blog
What are the Differences Between Temporary Table and Table Variable in SQL Server?
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...
Parse URL in SQL Server
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...
Procedure to Output Tables in HTML Format in SQL Server
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]...
