/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

-1 vote180 views2 answers
Mysql get day of week
SQL
1 vote172 views1 answer
Md5 encryption for existing records
SQL
1 vote174 views1 answer
Rows to comma separated values in mssql
SQL
0 vote277 views1 answer
Site:av.ru "files"
SQL
0 vote195 views2 answers
Plpgsql
SQL
1 vote176 views1 answer
Mysql text to decimal
SQL
0 vote177 views1 answer
See the structure of a table mysql
SQL
0 vote238 views1 answer
Mac os zsh: command not found: mysql
SQL
5 votes145 views1 answer
Alter table default value mysql
SQL
10 votes184 views3 answers
Sql select between two dates
SQL