Thanks guys, FLOAT did the trick. Sam.
----- Original Message ----- From: "Bostrup, Tore" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Friday, September 27, 2002 10:41 PM Subject: RE: DOUBLE > Float > > HTH, > Tore. > > -----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.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
