This is quite rudimentary but I've been wasting time on this. In the past I would normally do this update directly using the Design View however with this particular requirement I have to write a native query to perform this update. The update is shown below:
update TableA
set ColA='Some Value', ColB='Some value that redirects to this link <a href='http://www.google.com' />'
where ColC='Some condition'
It is important to ponder that ColB's data type is an nvarchar(max) and not a hyperlink. I am getting an Invalid syntax error on the first slash ('/') in the url. Does anybody know how to go about this?
