/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 vote371 views1 answer
Postgresql replace html tags from string
SQL
0 vote346 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote356 views4 answers
How to drop all tables in sql
SQL
0 vote368 views1 answer
Mysql date format unix timestamp
SQL
13 votes388 views4 answers
What is sql
SQL
27 votes374 views5 answers
Mysql set password for user
SQL
0 vote365 views1 answer
Guid string to binary better
SQL
0 vote346 views1 answer
Python mysql executemany
SQL
0 vote322 views1 answer
Jooq finding lastest value in table
SQL
-1 vote377 views1 answer
Pl/sql how to delete a trigger
SQL