Unable to create connection with Sql server

Question

When Creating connection to Sql server an error encountered -
Unable to add data connection, Couldn't load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc version 11.0.0.0
.
.
.
What does it mean. I have Sql Server 2008 and visual studio 2012 on my pc.

Answer 1

<b> Report Date:&nbsp;&nbsp; 2016-11-21 &nbsp;&nbsp;Optometrist: &nbsp;&nbsp;start &nbsp;&nbsp;Time:&nbsp;&nbsp; Consultant: &nbsp;&nbsp;Dr.suresh</b>

Answer 2

Hi,

 

Please try below query - 

DECLARE @x XML = '<table WIDTH="100%" CELLPADDING="1" CELLSPACING="1">

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
   <td><b>Report Date : </b>2016-11-21 </td>
  <td><b>Optometrist : </b> </td>
  <td><b>Start Time : </b> </td>
</tr>

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
        <td><b>Consultant : </b>Dr.Suresh </td>
</tr>

</table>'

SELECT t.c.value('.', 'NVARCHAR(MAX)')
FROM @x.nodes('*') t(c)

 

Reference :

https://stackoverflow.com/questions/38868364/sql-remove-all-html-tags-in-a-string