/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 vote115 views1 answer
Spring boot mysql connection properties
SQL
3 votes115 views1 answer
Force using index plsql
SQL
1 vote126 views5 answers
What is in operator in sql
SQL
0 vote111 views1 answer
Postgresql copy backup table
SQL
0 vote110 views1 answer
Limiting query result using where in sql
SQL
0 vote134 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote135 views1 answer
Traccar mysql
SQL
0 vote128 views2 answers
Clauses in mysql
SQL
1 vote115 views1 answer
Count mysql server db tables
SQL
0 vote111 views1 answer
Renommer table sql
SQL