/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 vote208 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote194 views1 answer
How to find total working hour in sql
SQL
0 vote206 views1 answer
Systems sql
SQL
0 vote188 views1 answer
Postgresql print sessions using the database
SQL
0 vote252 views1 answer
Mysql sum per week
SQL
0 vote169 views1 answer
Inser into example
SQL
0 vote238 views1 answer
MySQL update with subquery
SQL
0 vote196 views1 answer
Mysql select where field is a value
SQL
2 votes212 views1 answer
Python sql
SQL
0 vote179 views1 answer
Suse status MySQL
SQL