adspace


How to create hyperlink from returned sql query ?

Answer Posted / Desh Deepak Diwakar

In SQL Server, you can use the CHAR function to concatenate a hyperlink into your result set. For example: SELECT '<a href="https://www.example.com">Click here</a>' AS Hyperlink FROM MyTable; This will create a column named Hyperlink containing clickable links.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the different types of locks available in sql server?

1051


Why use identity in sql server?

1203


How to enter binary string literals in ms sql server?

1246


When should you use an instead of trigger?

1054


What is a view in sql?

1043


Can we do dml on views?

1039


What are the properties of the transaction?

1074


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1048


what is the difference between openrowset and openquery?

1197


How to convert character strings into numeric values?

1192


How to remove duplicate rows from table except one?

1090


How to provide default values to function parameters?

1261


Can sql servers link to other servers like oracle?

919


Equi join and non equi join is possible with sql server?

1134


Explain “row_number()” in sql server with an example?

1080