EXEC dbo.sp_generate_inserts @table_name = 'CM_DMMS', -- varchar(776)
@from = 'FROM CM_DMMS' -- varchar(800)

 

Trạng thái: Select thành công 

  

Column1 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000001',N'DV0001',N'DEP000000000014',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000002',N'BRN000000000387',N'DEP000000000068',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000003',N'BRN000000000388',N'DEP000000000081',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS000000000035',N'BRN000000000829',N'BRN000000000829',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000004',N'BRN000000000389',N'DEP000000000093',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000005',N'BRN000000000390',N'DEP000000000105',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000006',N'BRN000000000391',N'DEP000000000117',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000007',N'BRN000000000392',N'DEP000000000128',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000008',N'BRN000000000393',N'DEP000000000146',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000009',N'BRN000000000394',N'DEP000000000158',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000010',N'BRN000000000395',N'DEP000000000164',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000011',N'BRN000000000396',N'DEP000000000182',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000012',N'BRN000000000397',N'DEP000000000194',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000013',N'BRN000000000398',N'DEP000000000200',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000014',N'BRN000000000399',N'DEP000000000213',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000015',N'BRN000000000400',N'DEP000000000229',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000016',N'BRN000000000401',N'DEP000000000242',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000017',N'BRN000000000402',N'DEP000000000254',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000018',N'BRN000000000403',N'DEP000000000266',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000019',N'BRN000000000404',N'DEP000000000272',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000020',N'BRN000000000405',N'DEP000000000284',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000021',N'BRN000000000406',N'DEP000000000296',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000022',N'BRN000000000407',N'DEP000000000308',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000023',N'BRN000000000418',N'DEP000000000390',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000024',N'BRN000000000422',N'DEP000000000423',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000025',N'BRN000000000432',N'DEP000000000503',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000026',N'BRN000000000817',N'DEP000000000537',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000027',N'BRN000000000818',N'DEP000000000549',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000028',N'BRN000000000819',N'DEP000000000556',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000029',N'BRN000000000820',N'DEP000000000567',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000030',N'BRN000000000821',N'DEP000000000579',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000031',N'BRN000000001841',N'DEP000000000579',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000032',N'BRN000000001839',N'DEP000000000579',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000033',N'BRN000000001842',N'DEP000000000579',N'') 
INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000034',N'BRN000000001840',N'DEP000000000579',N'') 

Result ErrorDesc 
SUCCESSFULL