Get the Domain Name, Page Name and Query Parameter from a URL

YogeshHadiya33 answered on April 30, 2021 Popularity 1/10 Helpfulness 1/10

answer Get the Domain Name, Page Name and Query Parameter from a URL

Get the Domain Name, Page Name and Query Parameter from a URL

Comment

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]

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.sql-server-helper.com

Tags: get sql url

Link to this answer
Share Copy Link

Contributed on Apr 30 2021

YogeshHadiya33

0 Answers Avg Quality 2/10

Get the Domain Name, Page Name and Query Parameter from a URL

Contents

More Related Answers

Get the Domain Name, Page Name and Query Parameter from a URL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.