/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 vote273 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote263 views1 answer
Sql server update top n records
SQL
22 votes283 views3 answers
SQL CHEATSHEET
SQL
0 vote272 views4 answers
Database stuck at restoring state
SQL
14 votes291 views5 answers
Sql oracle limit
SQL
4 votes271 views2 answers
Postgresql default value
SQL
0 vote289 views1 answer
Mysql multiple primary keys
SQL
1 vote296 views1 answer
Spark sql convert string to date
SQL
1 vote295 views1 answer
Sql server read uncommitted
SQL
2 votes277 views1 answer
Sql ends with string
SQL