February 19, 2002 at 3:07 pm
What are the equivalents of Accesses "text" and "number" datatypes in SQL Server? For the number field, I need to be able to specify the length.
February 19, 2002 at 3:14 pm
Numeric for number, and varchar or char with a lenght of no more than 255 for the text.
Nermic has a precision and scale in the for NUMERIC(p,s), p = to the total max lenght, and s = to the total digits left of the decimal.
If you use a value in char or varchar greater than 255 the data stored in them will truncate.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy