/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 vote296 views1 answer
Count in sql and diff
SQL
0 vote308 views1 answer
Update sql sintax
SQL
0 vote280 views1 answer
Display first three characters sql
SQL
0 vote266 views1 answer
Sql right characters
SQL
1 vote279 views1 answer
Show table status command in mysql
SQL
0 vote297 views1 answer
Database xml sql
SQL
9 votes271 views4 answers
Mysql show table fields
SQL
0 vote328 views1 answer
Sparql list all graphs
SQL
17 votes285 views6 answers
Sql select distinct
SQL
0 vote302 views1 answer
SQL column name Oracle
SQL