ÿþ/* 

   Simple script to create two database tables for trying Volpet Software Table Diff.

   

   For information or support, please contact Giammarco Schisani (giammarco@volpet.com).



   This script has been tested against the following database servers:

     - Microsoft SQL Server 2000

     - Microsoft Desktop Engine 2000

     - Microsoft SQL Server 2005

     - Microsoft SQL Server 2008



   Thank you for trying Table Diff.

*/ 



BEGIN TRANSACTION t1;



/* CREATE the 'UsersLeft' table. */

CREATE TABLE [UsersLeft](

	[ID] [int] NOT NULL,

	[Name] [nvarchar](50) NOT NULL,

	[Surname] [nvarchar](50) NULL,

	[DateOfBirth] [datetime] NOT NULL,

	[Active] [bit] NOT NULL,

 CONSTRAINT [PK_UsersLeft] PRIMARY KEY CLUSTERED 

(

	[ID] ASC

))





/* Create the 'UsersRight' table; */

CREATE TABLE [UsersRight](

	[ID] [int] NOT NULL,

	[Name] [nvarchar](50) NOT NULL,

	[Surname] [nvarchar](50) NULL,

	[DateOfBirth] [datetime] NOT NULL,

	[Active] [bit] NOT NULL,

 CONSTRAINT [PK_UsersRight] PRIMARY KEY CLUSTERED 

(

	[ID] ASC

))





/* Insert records in the 'UsersLeft' table; */

SET DATEFORMAT YMD;

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (1,'1982-04-19 11:00:00.0',0,N'Giammarco',N'Schisani');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (2,'1980-05-04 00:00:00.0',0,N'Tommy',N'Blogs');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (3,'1978-12-01 00:00:00.0',0,N'Joel',N'Polska');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (4,'1982-04-15 00:15:00.0',1,N'Anna',N'Lesi');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (5,'1975-05-11 00:00:00.0',0,N'Markk',N'White');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (6,'1978-03-02 00:00:00.0',1,N'John',N'Blue');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (7,'1982-04-04 00:34:00.0',1,N'Darren',N'Cooler');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (8,'1982-04-19 00:00:00.0',1,N'Johnny',N'Foxet');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (9,'1980-05-04 00:00:00.0',0,N'Andrea',N'Schisani');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (12,'1975-05-11 00:00:00.0',0,N'Luigi',N'Mari');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (13,'1982-12-12 00:00:00.0',1,N'Ted',N'Delt');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (14,'1982-04-07 00:00:00.0',1,N'Vincent',N'Tester');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (15,'1981-03-03 00:00:00.0',1,N'Tom',N'Malt');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (19,'1975-12-12 00:00:00.0',0,N'Luky',N'Luke');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (20,'1979-09-17 00:00:00.0',1,N'Liz',N'Blues');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (22,'1983-04-12 00:00:00.0',1,N'Jason',N'Reilly');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (23,'1982-04-19 11:00:00.0',0,N'Thomas',N'Bridgewater');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (24,'1980-05-04 00:00:00.0',0,N'Seth',N'Anderson');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (25,'1978-12-01 00:00:00.0',0,N'Les',N'Atwater');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (26,'1982-04-15 00:15:00.0',1,N'Mac',N'Clearwater');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (27,'1975-05-11 00:00:00.0',0,N'Thaddeus',N'Addison');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (28,'1978-03-02 00:00:00.0',1,N'Maurice',N'Warner');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (29,'1982-04-04 00:34:00.0',1,N'Hunter',N'Brewster');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (30,'1982-04-19 00:00:00.0',1,N'Adrian',N'Walden');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (31,'1980-05-04 00:00:00.0',0,N'Kane',N'Truman');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (32,'1975-05-11 00:00:00.0',0,N'Julian',N'Trent');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (33,'1982-12-12 00:00:00.0',1,N'Abraham',N'Raymond');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (34,'1982-04-07 00:00:00.0',1,N'Benjamin',N'Swain');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (35,'1981-03-03 00:00:00.0',1,N'Robert',N'Lee Callahan');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (36,'1975-12-12 00:00:00.0',0,N'Paul',N'Montgomery');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (37,'1979-09-17 00:00:00.0',1,N'Kyle',N'Truman');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (38,'1983-04-12 00:00:00.0',1,N'Nat',N'Collins');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (39,'1982-04-19 11:00:00.0',0,N'Jack',N'Bridgewater');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (40,'1980-05-04 00:00:00.0',0,N'Devon',N'Kane');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (41,'1978-12-01 00:00:00.0',0,N'Martin',N'Randall');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (42,'1982-04-15 00:15:00.0',1,N'Nat',N'Blackwell');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (43,'1975-05-11 00:00:00.0',0,N'Gabriel',N'Abernathy');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (44,'1978-03-02 00:00:00.0',1,N'Pat',N'Bartholomew');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (45,'1982-04-04 00:34:00.0',1,N'Victor',N'Randall');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (46,'1982-04-19 00:00:00.0',1,N'Arnold',N'Montague');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (47,'1980-05-04 00:00:00.0',0,N'Franklin',N'Addison');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (48,'1975-05-11 00:00:00.0',0,N'Eldon',N'Sterling');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (49,'1982-12-12 00:00:00.0',1,N'Theodore',N'Blake');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (50,'1982-04-07 00:00:00.0',1,N'Raphael',N'Montague');

INSERT INTO [UsersLeft] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (51,'1981-03-03 00:00:00.0',1,N'Jesse',N'Houston');



/* Insert records in the 'UsersRight' table. */

SET DATEFORMAT YMD;

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (1,'1982-04-19 00:00:00.0',1,N'Giammarco',N'Schisani');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (2,'1980-05-04 00:00:00.0',1,N'Tommy',N'Bloggs');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (3,'1978-12-01 00:00:00.0',0,N'Joe',N'Polska');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (4,'1982-02-15 00:00:00.0',1,N'Anna',N'Lesi');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (5,'1975-05-11 00:00:00.0',0,N'Mark',N'White');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (6,'1978-03-02 00:00:00.0',1,N'John',N'Blu');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (7,'1982-04-07 00:00:00.0',1,N'Darren',N'Cooler');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (8,'1982-04-19 00:00:00.0',1,N'John',N'Foxet');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (9,'1980-05-04 00:00:00.0',1,N'Andreaa',N'Schisani');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (11,'1982-02-15 00:00:00.0',1,N'Marco',N'Blogs');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (12,'1975-05-11 00:00:00.0',0,N'Luigi',N'Mari');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (13,'1978-03-02 00:00:00.0',1,N'Jason',N'Delt');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (14,'1982-04-07 00:00:00.0',1,N'Vincent',N'Tester');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (15,'1981-03-03 00:00:00.0',1,N'Tom',N'Malt');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (16,'1982-04-19 11:00:00.0',0,N'Thomas',N'Bridgewater');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (17,'1980-05-04 00:00:00.0',0,N'Seth',N'Anderson');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (18,'1978-12-01 00:00:00.0',0,N'Les',N'Atwater');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (19,'1982-04-15 00:15:00.0',1,N'Mac',N'Clearwater');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (20,'1975-05-11 00:00:00.0',0,N'Thaddeus',N'Addison');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (21,'1978-03-02 00:00:00.0',1,N'Maureen',N'Warner');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (22,'1982-04-04 00:34:00.0',1,N'Hunter',N'Brewster');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (23,'1982-04-19 00:00:00.0',1,N'Adrian',N'Walden');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (24,'1980-05-14 00:00:00.0',0,N'Kane',N'Truman');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (25,'1975-05-11 00:00:00.0',0,N'Julian',N'Trent');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (26,'1982-12-12 00:00:00.0',1,N'Abraham',N'Raymond');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (27,'1982-04-07 00:00:00.0',0,N'Benjamin',N'Swain');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (28,'1981-03-03 00:00:00.0',0,N'Robert',N'Lee Callahan');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (29,'1975-11-12 00:00:00.0',0,N'Paul',N'Montgomery');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (30,'1979-09-17 00:00:00.0',1,N'Kyli',N'Truman');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (31,'1983-04-12 00:00:00.0',1,N'Nat',N'Collins');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (32,'1982-04-19 11:00:00.0',0,N'Jack',N'Bridgewater');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (33,'1980-05-04 00:00:00.0',0,N'Devon',N'Kane');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (34,'1978-12-01 00:00:00.0',0,N'Martin',N'Randall');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (35,'1982-04-15 00:15:00.0',1,N'Nat',N'Blackwell');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (36,'1975-05-11 00:00:00.0',0,N'Gabriel',N'Abernathy');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (37,'1978-03-02 00:00:00.0',1,N'Pat',N'Bartholomew');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (38,'1982-04-04 00:34:00.0',1,N'Victor',N'Randall');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (39,'1982-04-19 00:00:00.0',1,N'Arnold',N'Montague');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (40,'1980-05-04 00:00:00.0',0,N'Franklin',N'Addison');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (41,'1975-05-11 00:00:00.0',0,N'Eldon',N'Sterling');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (42,'1982-12-12 00:00:00.0',1,N'Theodore',N'Blake');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (43,'1982-04-07 00:00:00.0',1,N'Raphael',N'Montague');

INSERT INTO [UsersRight] ([ID],[DateOfBirth],[Active],[Name],[Surname]) VALUES (44,'1981-03-03 00:00:00.0',1,N'Jesse',N'Huston');



COMMIT TRANSACTION t1;