| Author |
 Topic  |
|
dougancil
Posting Yak Master
USA
217 Posts |
 Posted - 09/01/2010 : 10:36:18
|
Tara,
here is the script that SSMS Created for the Create Table:
CREATE TABLE [dbo].[Memberdata] (
[ID] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Firstname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Lastname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Fullname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Speciality] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Company] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[phonenumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[fax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[birthday] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[streetaddr1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[streetaddr2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[city] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[state] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[zip] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Last_Updated] [datetime] NOT NULL ,
[Date_Added] [datetime] NOT NULL
) ON [PRIMARY]
GO
Though since all of those fields will accept NULL input, I'm not 100% sure if thats correct. |
 |
|
|
dougancil
Posting Yak Master
USA
217 Posts |
Posted - 09/01/2010 : 10:57:22
|
Here is the script from SSMS for the newclient table:
CREATE TABLE [dbo].[newclients] (
[ID] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Firstname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lastname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Fullname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[speciality] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[company] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[phonenumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[fax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[birthday] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[streetaddr1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[steetaddr2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[city] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[state] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[zip] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[last_updated] [datetime] NULL ,
[date_added] [datetime] NULL
) ON [PRIMARY]
GO |
|
|
|
dougancil
Posting Yak Master
USA
217 Posts |
Posted - 09/07/2010 : 10:24:00
|
Tara,
Have I given you the information that you needed?
Thank you
Doug |
|
|
|
dougancil
Posting Yak Master
USA
217 Posts |
Posted - 09/08/2010 : 10:52:23
|
I got this to work finally, the query is as follows:
insert into msbtotal.dbo.newclients
SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join
msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id =
msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is
null
Thanks for everyones help.
Doug |
|
|
|
Topic |
|
|
|
SQl Database compare
