1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
INSERT INTO PROJET (nom_prj, phase_prj, indice_base_prj, transfert_prj, id_type_tprj, id_etat_eprj, id_origine_o)
VALUES ( 'toto',
1,
'Y:\\',
0,
0,
1,
2);
GO
DECLARE @idProjet AS int;
SET @idProjet = @@IDENTITY;
INSERT INTO DOCUMENT (DocumentExtension, DocumentName, Document)
SELECT 'zip' AS DocumentExtension,
'Documentation2' AS DocumentName,
* FROM OPENROWSET(BULK 'T:\\Documentation.zip', SINGLE_BLOB) As Document;
GO
DECLARE @idDocument AS int;
SET @idDocument = @@IDENTITY;
INSERT INTO EST_DEFINI_PAR (id_objet_prj, id_document_d) VALUES (@idProjet,@idDocument);
GO |
Partager