November 2, 2011 at 12:53 pm
Hello Friends, i am using SSMA to convert my Access DB to sql database but i am confused with two datatypes " Number with Long integer as Field size and Decimal as Auto. Please let me know what would be the datatype in SQL
2. Memo datatype in Access ..what would be the datatype in SQL.
Please help
Datatype :- Number
Fileld Size :- Long Integer
Decimal Places : Auto
-------
Other Datatype :- Memo
November 2, 2011 at 1:03 pm
Long Integer in Access = Integer in SQL Server.
Memo = varchar(max)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 2, 2011 at 1:12 pm
GSquared (11/2/2011)
Long Integer in Access = Integer in SQL Server.Memo = varchar(max)
IIRC, and this may have changed, converting an Access MEMO field to SQL Server becomes an NTEXT or TEXT data type column. If you want it to be varchar(max) or nvarchar(max), you have to do that manually.
At least that is what I have seen in the past.
November 2, 2011 at 1:52 pm
Thank you for your reply. As i mentioned earlier in my post that Datatype is Number and Field size mentioned as Long integer and Decimal places =Auto in access for that particular column. What this Decimal places will be in SQL
November 2, 2011 at 2:11 pm
You will need to specify the number of decimal places unless you convert to a float type. If you convert to Int - there will be 0 decimal places.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 2, 2011 at 2:19 pm
Does the data in that column store decimal values, or just integers?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 2, 2011 at 5:19 pm
Thank you all for the quick response. I checked the data and i did not see any decimal value. All the data in that column is INT but just for testing purpose i tried to enter 45.00 value and as soon as i saved it was showing 45 but no 00. Really confused here now
November 3, 2011 at 6:22 am
sqlquest2575 (11/2/2011)
Thank you all for the quick response. I checked the data and i did not see any decimal value. All the data in that column is INT but just for testing purpose i tried to enter 45.00 value and as soon as i saved it was showing 45 but no 00. Really confused here now
Access will list the decimals as "automatic" for integer data types. It's just an interface issue, it doesn't actually affect the data storage. Ignore it for that column.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 3, 2011 at 8:24 am
sqlquest2575 (11/2/2011)
Thank you all for the quick response. I checked the data and i did not see any decimal value. All the data in that column is INT but just for testing purpose i tried to enter 45.00 value and as soon as i saved it was showing 45 but no 00. Really confused here now
In SQL, an INT will not have anything to the right of the decimal. An INT is a whole number only. As Gus said, Access does it just for display and should be ignored.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply