/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 vote341 views1 answer
Convert polygon to text in mysql
SQL
1 vote358 views1 answer
How to remove identity from a column in sql server
SQL
0 vote329 views1 answer
Uncomment listen_address=localhost
SQL
0 vote309 views1 answer
Store query result in variable sql
SQL
1 vote349 views1 answer
Quit mysql
SQL
0 vote327 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote443 views1 answer
Sp help text in postgresql
SQL
1 vote355 views1 answer
Print year of a date sql
SQL
1 vote324 views1 answer
Oracle sql create or replace view
SQL
0 vote332 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL