/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 vote105 views1 answer
Mariadb get column names from table
SQL
0 vote110 views1 answer
SQL FROM-Klausel
SQL
0 vote120 views1 answer
Default column value in sql same as another column laravel
SQL
1 vote108 views1 answer
Psql connections
SQL
0 vote112 views1 answer
Sql examples from framework
SQL
0 vote108 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote103 views1 answer
Char varchar nvarchar sql
SQL
0 vote130 views1 answer
Varchar2 length in oracle
SQL
2 votes113 views1 answer
Sql server find columns list in tables
SQL
0 vote99 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL