/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 vote239 views1 answer
Typical max-connect-errors mysql
SQL
0 vote214 views1 answer
Closure in sql
SQL
0 vote195 views1 answer
Sql select most frequent value in group
SQL
0 vote199 views1 answer
Sql select column names starting with
SQL
1 vote200 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote229 views1 answer
Sql int vs integer
SQL
24 votes179 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote203 views1 answer
Monthly Birthday SQL Query
SQL
0 vote227 views1 answer
Define a variable in mysql from select
SQL
0 vote198 views2 answers
How to find sql server agent jobs related to a database
SQL