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 27 28 29 30 31 32 33
|
INSERT [Documents]
(
ModuleID ,
FileId ,
DocumentDisplayName ,
DocumentDescription ,
DocumentKeyWords ,
DocumentCreatedDate ,
DocumentCreatedByUser,
DocumentUpdatedDate ,
DocumentUpdatedByUser,
DocumentBuildDate ,
DocumentLastModifDate,
DocumentDate
)
SELECT (387) ,
TOP 1 FileID ,
('R110-1 à R110-3') ,
('R110-1 à R110-3') ,
('R110-1 à R110-3') ,
('30/11/1999 00:00:00'),
(1) ,
('13/12/2004 18:07:32'),
(1) ,
('30/11/1999 00:00:00'),
('13/12/2004 18:07:32'),
('30/11/1999 00:00:00')
FROM Files
RIGHT JOIN
(SELECT 'toto'
)
WHERE filename='code10.doc' |
Partager