/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 vote168 views1 answer
Not equal to blank in mysql
SQL
0 vote217 views1 answer
Postgres row expiration
SQL
4 votes162 views1 answer
Sql any
SQL
0 vote172 views1 answer
Mysql shell set time_zone
SQL
1 vote119 views1 answer
Postgres division by zero
SQL
0 vote176 views1 answer
Separator mysql
SQL
2 votes155 views2 answers
Postgresql date at timezone
SQL
0 vote187 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote208 views1 answer
Mysql 3 months ago
SQL
0 vote159 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL