How to create hyperlink from returned sql query ?



How to create hyperlink from returned sql query ?..

Answer / 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

More SQL Server Interview Questions

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1 Answers  


How to use "begin ... End" statement structures in ms sql server?

1 Answers  


what is the difference between group and having give an example with query and sample output

7 Answers  


Why use identity in sql server?

0 Answers  


How are SQL Server databases physically stored under Windows 2000?

1 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


How can windows applications connect to sql servers via odbc?

1 Answers  


What is the difference between locking and multi-versioning?

1 Answers  


Describe in brief sql server monitoring ways.

1 Answers  


how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,


What is the difference between a view and a stored procedure?

1 Answers  


What is Deadlock?

4 Answers   Satyam,


Categories