/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 vote374 views1 answer
Authentication modes in sql server
SQL
3 votes398 views2 answers
Oracle sql first day of month
SQL
0 vote353 views1 answer
How to get employee having maximum experience in mysql
SQL
1 vote373 views1 answer
SQL query to get all table records count from a database
SQL
0 vote368 views1 answer
Sql developer connect to sql server
SQL
21 votes376 views4 answers
Add column mssql
SQL
0 vote372 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote372 views1 answer
How to change null display in psql
SQL
1 vote374 views1 answer
Oracle truncate partition
SQL
0 vote380 views1 answer
Regex any word except sql
SQL