/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 vote342 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote322 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote356 views1 answer
Sql server udf performance
SQL
0 vote363 views3 answers
Join
SQL
0 vote354 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote342 views1 answer
Data structures in sql
SQL
16 votes369 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
12 votes329 views2 answers
Delete all data in neo4j
SQL
0 vote335 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote365 views1 answer
Sql how to get courses that i have made prerequisites
SQL