/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

0 vote303 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote295 views1 answer
Ora 00001 error catch plsql
SQL
1 vote318 views1 answer
Size of all tables in a schema oracle
SQL
-1 vote299 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote347 views1 answer
Create a view in sqlite
SQL
2 votes323 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote318 views1 answer
Influxdb export to csv
SQL
7 votes299 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
-1 vote286 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
17 votes296 views6 answers
Sql current date
SQL