/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

6 votes187 views2 answers
Oracle
SQL
6 votes219 views1 answer
To count number of rows in SQL table
SQL
1 vote303 views1 answer
Aqua Data studio postgresql ssl
SQL
6 votes189 views1 answer
Phpmyadmin password root
SQL
0 vote181 views1 answer
Uuid sqlalcomany
SQL
11 votes245 views2 answers
You are using safe update mode
SQL
1 vote212 views1 answer
Postgres format date in select
SQL
1 vote185 views1 answer
How to select random rows from table
SQL
1 vote212 views1 answer
Sql list all procedures
SQL
0 vote218 views2 answers
What is rownum in oracle
SQL