/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

2 votes156 views1 answer
Query to find table size in oracle 12c
SQL
7 votes137 views1 answer
Sql disable safe mode
SQL
1 vote140 views2 answers
Pl sql case
SQL
1 vote178 views1 answer
Oracle drop chain step
SQL
-1 vote150 views2 answers
Create temporary table sql
SQL
2 votes138 views1 answer
Oracle virtual column
SQL
0 vote157 views1 answer
.sql File Run in PSQL
SQL
0 vote151 views1 answer
Sql drop default
SQL
0 vote141 views1 answer
Add column in sql server ubuntu
SQL
0 vote136 views1 answer
How to declare variable date in mysql
SQL