/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 vote172 views1 answer
How to see all table partition in oracle
SQL
0 vote189 views3 answers
Mysql regex replace
SQL
1 vote166 views1 answer
Limit offset order by mysql
SQL
0 vote188 views1 answer
Python sql last insertend
SQL
1 vote201 views1 answer
Insert pg result of select
SQL
2 votes174 views1 answer
Pandas to sql index
SQL
0 vote199 views1 answer
Sqlite explain plan
SQL
0 vote226 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote199 views1 answer
Add multiple row table pl sql
SQL
0 vote196 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL