Information générale
Catégorie:
Codage, syntaxe et commandes
>>Is there some way to force the type of field in a table created by SQL? I know with currency, you can do $0.00 AS ... But what about the other types.
>>
>>I have a line that says 0 AS group. The trouble is that it makes it a N(1,0). When I later try and fill the group in, I can only put single digits. I suppose I could put 00000 AS group to make it bigger, but what I really want is to make it an integer.
>>
>>Is there any way to do that?
>>
>>Thanks,
>>
>>-Michelle
>
>You may use ALTER TABLE to change data type
Brute force method, eh? Well, I suppose that'll work. I was hoping for something in the SQL.
Thanks,
-Michelle
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement