/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 vote193 views1 answer
Mysql pretty date format
SQL
0 vote196 views1 answer
Search In the Data using ObjectName
SQL
0 vote197 views2 answers
Execute stored procedure without db set
SQL
0 vote220 views2 answers
T sql null or empty string
SQL
0 vote210 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote217 views1 answer
Hour differeence in mysql
SQL
0 vote177 views1 answer
Postgresql conectar
SQL
41 votes228 views6 answers
Alter table add column in SQL Server
SQL
0 vote189 views1 answer
Alter table myisam to innodb
SQL
0 vote217 views2 answers
Amazon linux postgresql client
SQL