Sam, what are you storing? You can use DECIMAL or NUMERIC - both the same thing in SQL Server - to store numbers you used to call "double-precision". If you're storing currency values, there's a MONEY data type with features that may suit your needs.
These types are outlined in SQL Server Books Online... do you have it installed? -----Original Message----- From: Sam Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 11:21 AM To: ActiveServerPages Subject: DOUBLE Hi In access I can set the field size of a number datatype to be "Double", now im creating the same table in SQL Server 7, what do I put in my SQL script (which creates the table) to make the equivalent field? Currently ive got: CREATE TABLE tblData ( [ID] numeric IDENTITY(1,1), [Section] varchar (255) NULL, [Content] text NULL, [SectionNo] int , <---------- what goes here to make it double? [DateUpdated] datetime, [DateSent] datetime ) Thanks! Sam --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
