tsql - SQL Cast string as hyperlink -
my source data come pervasive sql , returned in excel (as external data query). test code in pcc.
my tables contains file path , file name , when concatenated sting value. want cast string hyperlink value don't have convert in excel.
select path + file link file_source
there no hyperlink data type in sql server. need use varchar i.e. varchar(100) store link , application or excel display hyperlink.
Comments
Post a Comment