/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

15 votes141 views2 answers
Select Options
SQL
2 votes154 views1 answer
Install postgresql centos 5
SQL
11 votes171 views2 answers
Import sql file laravel cmd
SQL
2 votes173 views1 answer
Dbms transaction (psql)
SQL
3 votes136 views2 answers
Mysql config user password
SQL
1 vote171 views1 answer
Oracle check table lock
SQL
3 votes144 views1 answer
Oracle apex call duration
SQL
0 vote149 views1 answer
How to get nth number in sql
SQL
32 votes146 views6 answers
How to change column name in sql
SQL
0 vote138 views1 answer
Mysql join same table multiple times group by
SQL