1 2 3
|
INSERT INTO [dbo].[import] ([import_function], [carriertype], [lastname], [initials], [middlename], [gender], [title], [personnelnr], [departmentname], [company], [unit], [phonenumber], [arrivaldatetime], [leavedatetime], [contactperson_personnelnr], [freefieldid], [freefielddata], [vendor_code], [picture_file], [badgetype], [badgenumber], [blocked], [temporarybadgetype], [temporarybadgenumber], [verifiertype], [verifierid], [template], [entrancename], [entrancegroupname], [datetimeschedulename], [validfrom], [validto], [disabled], [countgroup], [status] )
VALUES ( 1, 1, 'Dupont', 'pierre', '', 0, '', '14', 'NULL', '', NULL, '', '2000-05-10 00:00:00.000', NULL, NULL, NULL, NULL, NULL, 'C:\photo\14.jpg', 'Badge', '14', NULL, NULL, NULL, NULL, NULL, 'Permanent', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL ) |
Partager