/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 vote327 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote298 views1 answer
Declaring variables in pl sql
SQL
1 vote338 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote384 views1 answer
Différence entre deux dates sql oracle
SQL
2 votes320 views2 answers
Postgres select duplicate columns
SQL
17 votes322 views3 answers
Postgresql version command
SQL
0 vote321 views1 answer
Oracle c# multiple update sql
SQL
3 votes339 views2 answers
To_char sql
SQL
13 votes297 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote350 views2 answers
T sql null or empty string
SQL