Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Float Data Type
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01089757
Message ID:
01089819
Vues:
38
I understand, althought I'm not totaly sure how SPT works. Can you elaborate?

Thanks




>In addition, you will have to double single quotes in the strings, if ther are any, or you will get syntax error. SPT parameters allow to avoid this problem.
>
>>ohh, I see now. Thanks!
>>
>>
>>>If you want to build SQL command as string, use TEXTMERGE (see below). It makes code readable. The string values have to be enclosed in single quotes. You may consider using SPT parameters ('?') instead.
>>>
>>>>Ok, I have another problem with this code.
>>>>
>>>>SWL is reporting "The name 'JVILLAGOMEZ' is not permitted in this context. Only constants, expressions,
>>>>or variables allowed here. Column names are not permitted."
>>>>
>>>>It must be referencing the 'user_name' column, but I don't see why.
>>>>
>>>>Here's the CREATE TABLE code again:
>>>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform