1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE produit
(idpro integer IDENTITY(1,1) NOT NULL
,codpro as CAST(SUBSTRING(lieupro,1,1)+'-'+CAST(year(datpro) AS char(4))+'-' AS char(20)) PERSISTED
,nompro char(10) NOT NULL
,datpro datetime DEFAULT GETDATE() NOT NULL
,lieupro char(15) NOT NULL
,prixpro float
,codfour integer
,CONSTRAINT ver_codpro PRIMARY KEY(idpro)
,CONSTRAINT ver_nompro UNIQUE (nompro)
,CONSTRAINT ver_lieupro CHECK (lieupro IN('france','japan','united states'))
)
INSERT INTO produit (nompro, lieupro, prixpro, codfour)
VALUES('MonProduit', 'france', 12.15, 0123)
SELECT * FROM produit |
Partager