/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 vote255 views1 answer
Wordpress change url phpmyadmin
SQL
1 vote256 views2 answers
How to add amount between date in sql
SQL
3 votes237 views3 answers
Mysqldump: couldn
SQL
-1 vote248 views1 answer
MYSQL stored procedure select from
SQL
0 vote253 views1 answer
Like sql for second letter of the family name
SQL
0 vote259 views1 answer
View psql output in horizontal scrolling
SQL
0 vote244 views1 answer
Use between operator in mysql
SQL
0 vote273 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote241 views1 answer
How to get all values in a table mysql in c#
SQL
13 votes269 views1 answer
Fetch first 5 rows in oracle sql developer
SQL