/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 vote122 views1 answer
Netstat -tln mysql
SQL
9 votes156 views3 answers
Date format in sql
SQL
2 votes176 views1 answer
Oracle Column Names of a table
SQL
0 vote123 views1 answer
Mysql add to value
SQL
-1 vote121 views1 answer
Sql getdate date only
SQL
14 votes152 views3 answers
Inner join sql oracle
SQL
16 votes143 views2 answers
Sql vs nosql
SQL
2 votes143 views1 answer
Sql get the name of user pc
SQL
10 votes137 views3 answers
Sql check double value
SQL
3 votes116 views2 answers
Mysql add 2 hours
SQL