/SQL/Get the Domain Name, Page Name and Query Parameter from a URL

Get the Domain Name, Page Name and Query Parameter from a URL

DECLARE @URL    VARCHAR(1000)
SET @URL = 'http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tid=58'

SELECT SUBSTRING(@URL, 8, CHARINDEX('/', @URL, 9) - 8) AS [Domain Name],
       REVERSE(SUBSTRING(REVERSE(@URL), CHARINDEX('?', REVERSE(@URL)) + 1,
       CHARINDEX('/', REVERSE(@URL)) - CHARINDEX('?', REVERSE(@URL)) - 1)) AS [Page Name],
       SUBSTRING(@URL, CHARINDEX('?', @URL) + 1, LEN(@URL)) AS [Query Parameter]

Source: sql-server-helper.com

Similar codes

0 vote181 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
5 votes140 views2 answers
Oracle timestamp to date
SQL
0 vote142 views1 answer
Select other columns with distinct
SQL
0 vote299 views1 answer
Sql change a colum to unique
SQL
0 vote188 views1 answer
Generate random & unique mysql string
SQL
0 vote139 views1 answer
Mysql table variables
SQL
0 vote184 views1 answer
Isnull in sqlite
SQL
0 vote165 views1 answer
Rabbitmq service not starting
SQL
0 vote149 views1 answer
Allow external access to mysql
SQL
0 vote151 views1 answer
Call object contructor and call methods of object
SQL