Want to build the ChatGPT based Apps? Start here
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
narasiman rao
1.7k
519
709.2k
How to remove the table tr td in sql server
Dec 11 2017 3:20 AM
i have one table in that table i have one column in that record as follows
SummaryList record as follows
<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>
i want to remove table tr td and i want only content as follows
from the above i want output as follows
Report Date: 2016-11-21 Optometrist: start Time: Consultant: Dr.suresh
for that how to do using sql server
Reply
Answers (
2
)
how to copy database and use to other system in sql server.
XML parsing: line 22, character 2, whitespace expected