/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 vote257 views1 answer
Mysql relationships between tables
SQL
0 vote232 views1 answer
Psql list view rules
SQL
2 votes258 views1 answer
How to select from mssql
SQL
0 vote230 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote249 views1 answer
Sql cmd no truncate
SQL
26 votes228 views6 answers
Modify column name in sql
SQL
1 vote240 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
10 votes228 views2 answers
Sql merge statement
SQL
0 vote224 views4 answers
Forenkey code alchemy sql
SQL
1 vote229 views1 answer
Show all event schedular on mysql
SQL