/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

1 vote339 views3 answers
Create table from existing table in sql
SQL
9 votes209 views1 answer
Identity insert on sql server
SQL
3 votes222 views4 answers
Stop MySQL
SQL
0 vote204 views1 answer
Mysql page segment
SQL
0 vote240 views1 answer
Cahnge column name apex oracle
SQL
0 vote221 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote228 views1 answer
Postgresql define pk sequence next number
SQL
0 vote209 views1 answer
Mariadb mysql root access denied
SQL
27 votes271 views3 answers
Mysql delete row
SQL
-1 vote229 views1 answer
Mysql order by on condition
SQL