Sql server text insert

[bladde_89]

how to do insert text into database and it looks like what i inserted

i mean

lets say i insert this :

<p>
<strong>
strong text
<em>
strong and emphasised text
</strong>
just emphasised text
</em>
</p>



and i want to look like this instead sql server show as this:

<p> <strong> strong text <em> strong and emphasised text </strong> just emphasised text </em> </p

in one line

help plz!!!!!

 

[kyeana]

The database is meant for storing data. It isn't normally meant for viewing it and formatting it from within the database. Having it appear as strong/bold/whatever should probably be done the application that uses the database (the business logic).

That being said, if there was a way to get it to show up like that, it would be specific to the program you were using to view the database (to the best of my knowledge). I doubt it exists, but i don't have much experience with this so i could be mistaken.

 

[Pyroflea]

SQL databases are menat for storing data. You can format the output of the query.