Comments
Sort by recent activity
ok, here they are:
sql7
CREATE TABLE [dbo].[CROSS_BENEFIT]
(
[IDCROSSBENEFIT] [int] NOT NULL IDENTITY(1, 1),
[IDBENEFIT] [int] NOT NULL,
[IDCOUNTRY] [int] NOT NULL,
[IDTYPEDIMENSIONGROUP] [int] NOT NULL,
[DATASENSE] [int] NOT NULL,
[NUMEROSITY] [int] NULL,
[PERCENTAGE] [real] NULL
)
sql2005
CREATE TABLE [dbo].[CROSS_BENEFIT]
(
[IDCROSSBENEFIT] [int] NOT NULL,
[IDBENEFIT] [int] NOT NULL,
[IDCOUNTRY] [int] NOT NULL,
[IDTYPEDIMENSIONGROUP] [int] NOT NULL,
[DATASENSE] [int] NOT NULL,
[NUMEROSITY] [int] NULL,
[PERCENTAGE] [real] NULL
)
These are the tables, SQL Compare highlights IDENTITY(1, 1)
in the options I checked, beyond the default options,
'Constraint and index names'
'Identity seed and increment values'
'Collations'
'Indentity properties'
thank you / comments
ok, here they are:
sql7
CREATE TABLE [dbo].[CROSS_BENEFIT]
(
[IDCROSSBENEFIT] [int] NOT NULL IDENTITY(1, 1),
[IDBENEFIT] [int] NOT NULL,
[IDCOUNTRY] [int] NOT NULL,
[IDTYPEDIMENSIONGROUP] [int] NOT...