| Код |
INSERT INTO Client(id_Person,id_Partner) VALUE(10,9)
|
| Код |
CREATE TABLE [dbo].[Client] (
[id] int IDENTITY(1, 1) NOT NULL,
[id_Person] int NOT NULL,
[id_Partner] int DEFAULT 9 NOT NULL,
CONSTRAINT [Client_uq] UNIQUE ([id_Person]),
CONSTRAINT [PK__Cleint__32137F9D94] PRIMARY KEY CLUSTERED ([id]),
CONSTRAINT [Cleint_fk] FOREIGN KEY ([id_Person])
REFERENCES [dbo].[Person] ([id])
ON UPDATE CASCADE
ON DELETE CASCADE,
CONSTRAINT [Client_fk] FOREIGN KEY ([id_Partner])
REFERENCES [dbo].[Partner] ([id])
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
ON [PRIMARY]
GO
|
ошибка:
Incorrect syntax near 'VALUE'. |
