Activity overview
Latest activity by dominic99
No. I use dll from my own application (we has developer license).
Field Config contain an XML file. / comments
No. I use dll from my own application (we has developer license).
Field Config contain an XML file.
Yes.. [image] This is script for table tb_SharedConfig
I`m rename table (and all indexes)
tb_SCg = tb_SharedConfig / comments
Yes.. This is script for table tb_SharedConfig
I`m rename table (and all indexes)
tb_SCg = tb_SharedConfig
This is SQL script for table
CREATE TABLE [dbo].[tb_SCg] (
[Version] [int] IDENTITY (1, 1) NOT NULL ,
[Config] [ntext] COLLATE Latin1_General_CI_AI NOT NULL ,
[IpAddress] [varchar] (100) COLLATE Latin1_General_CI_AI NOT NULL ,
[UserId] [smallint] NOT NULL ,
[DateCreated] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_SCg] WITH NOCHECK ADD
CONSTRAINT [PK_tb_SCg] PRIMARY KEY CLUSTERED
(
[Version] DESC
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_SCg] ADD
CONSTRAINT [DF_tb_SCg_DateCreated] DEFAULT (getdate()) FOR [DateCreated]
GO / comments
This is SQL script for table
CREATE TABLE [dbo].[tb_SCg] (
[Version] [int] IDENTITY (1, 1) NOT NULL ,
[Config] [ntext] COLLATE Latin1_General_CI_AI NOT NULL ,
[IpAddress] [varchar] (100) COLLATE La...
The table has index on column Version.
The table has only 1 row [image] / comments
The table has index on column Version.
The table has only 1 row
SQLDataCompare can not create script for table with ntext
In ntext field xml file is placed
Structure of table:
Version int 4 - primary key, identity
Config ntext 16 - not null
IpAdress varchar 100 - not null
UserId smallint 2 - not null
DateCreated datet...