/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 vote89 views1 answer
Mysql timeout 30 seconds
SQL
1 vote123 views1 answer
Select if then postgresql
SQL
5 votes122 views1 answer
Oracle ora-00054 causes
SQL
0 vote126 views1 answer
Psotgres multiple values
SQL
2 votes127 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote123 views4 answers
User defined function sql
SQL
0 vote113 views2 answers
Add new column after in sql
SQL
0 vote130 views1 answer
ALV GRID events
SQL
8 votes130 views2 answers
Oracle undo usage
SQL
0 vote92 views1 answer
Create duplicate table postgres
SQL