if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[UserProfiles]') and OBJECTPROPERTY(id, N'IsForeignKey') =
1)
ALTER TABLE [dbo].[Invoices] DROP CONSTRAINT UserProfiles
GO
CREATE TABLE [dbo].[UserProfiles2] (
[UserID] [int] IDENTITY (100, 1) NOT NULL ,
[CompanyID] [int] NOT NULL ,
[Username] [varchar] (50) NULL ,
[Password] [varchar] (50) NULL ,
[Datestamp] [smalldatetime] NULL ,
[Email] [varchar] (255) NULL ,
[TaxID] [varchar] (20) NULL ,
[Hourly] [int] NULL ,
[Percentage] [int] NULL ,
[Payroll] [decimal](18, 0) NULL ,
[PayrollStart] [datetime] NULL ,
[PayrollEnd] [datetime] NULL ,
[SocialSecurityTax] [money] NULL ,
[FederalTax] [money] NULL ,
[StateTax] [money] NULL ,
[Company] [varchar] (255) NULL ,
[PrimaryAcct] [int] NULL ,
[FirstName] [varchar] (255) NULL ,
[LastName] [varchar] (255) NULL ,
[Address1] [varchar] (255) NULL ,
[Address2] [varchar] (255) NULL ,
[City] [varchar] (100) NULL ,
[State] [varchar] (50) NULL ,
[Zip] [varchar] (15) NULL ,
[Phone] [varchar] (50) NULL ,
[Fax] [varchar] (50) NULL ,
[Browser] [varchar] (100) NULL ,
[Description] [text] NULL ,
[Image] [varchar] (50) NULL ,
[LeftOver] [money] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
this a part of the script....
L
-----Original Message-----
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: mercoled� 22 agosto 2001 11.26
To: CF-Talk
Subject: RE: ms sql to ms access
Lorenzo
> i have a sql script and i wont this to became an access db....
Can you post the script?
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
