/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

3 votes165 views4 answers
Truncate syntax in sql
SQL
0 vote151 views1 answer
Trigger value from maltiple table to single table mysql
SQL
2 votes149 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes150 views3 answers
How to remove unique key constraint in mysql
SQL
3 votes119 views2 answers
Coalesce mysql
SQL
0 vote151 views1 answer
Soql update query
SQL
4 votes151 views1 answer
Mysql ip address
SQL
0 vote166 views2 answers
How to get the date from datetime in mysql
SQL
3 votes158 views1 answer
Mysql insert on dupèlicate
SQL
0 vote171 views1 answer
Java spring boot connect to sql server
SQL