/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 vote189 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote199 views1 answer
What is between keyword used for
SQL
0 vote195 views1 answer
T-SQL Retry (deadlock)
SQL
3 votes227 views2 answers
Synonym oracle
SQL
2 votes209 views2 answers
Mysql add hours to time field
SQL
4 votes201 views2 answers
Postgre sql create table
SQL
0 vote323 views2 answers
Mysql insert rows to another database
SQL
0 vote190 views1 answer
Restart sql server command line linux
SQL
0 vote185 views1 answer
Remove default constraint sql server
SQL
0 vote201 views1 answer
Oracle SQL join three tables and group by column
SQL