INSERT INTO #Request.prefix_db_agency#.files ( AgencyId, PatientId, Title, FileName, FileType, Dup_file_name, File, CreatedBy ) VALUES ( , , , , , , , ) SELECT LAST_INSERT_ID() AS fileId