/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 vote191 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote253 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
5 votes261 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote190 views3 answers
Delete in SQL SERVER
SQL
0 vote198 views1 answer
Sql server phone constraint
SQL
0 vote190 views1 answer
Geopoint from json mysql function
SQL
5 votes174 views4 answers
Describe table postgres
SQL
2 votes181 views1 answer
Mysql set value as null
SQL
1 vote249 views2 answers
Intersect sql
SQL
-1 vote219 views3 answers
SQL MM/dd/yyyy format
SQL