Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Associated statement is not prepared
Message
 
À
07/12/2012 15:01:23
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01559065
Message ID:
01559084
Vues:
44
>Why not change the chr(13)? The issue is that SQL eats the chr(13) and I need the line breaks to be as entered, so I change it 1) to something that I wouldn't use usually, and 2) something that HTML would understand, since certain records get exported for HTML display.

They are entered just you didn't see them with SSMS. hides these chars.
I don't know why, maybe the grid control used to show data has this behavior, but the line break is there.

>As far as the 'True' vs .t., SQL, at least our set up, doesn't like/understand .t. being passed in.

Then maybe you use Char fields not BIT one?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform