USE [namedatabase]
GO
delete tblMoarefiePersonel
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'32', N'10002', N'ابراهيم', N'عربش', N'لفته', N'1741224365', N'1741224365', N'اهواز', N'اهواز', N'13710814', N'14041101', N'6', N'کارگرپمادسازي', N'1', N'1274AG', N'1', N'1', N'1', N'0', N'0', N'11919097', N'9009006145', N'100', N'', N'0', N'', N'0', N'', N'12', NULL, N'1', N'1111111111', N'0', N'01', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'53', N'10001', N'مهدي', N'خوش اخلاق', N'عليرضا', N'638', N'5269523868', N'شوش', N'شوش', N'13610512', N'14041101', N'6', N'مديربازاريابي و فروش', N'', N'', N'4', N'1', N'1', N'0', N'0', N'50599938', N'9009006145', N'', N'6393461060040470', N'0', N'', N'09100223208', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'49', N'10009', N'عادل', N'حرداني', N'حسن', N'1884', N'1754367259', N'اهواز', N'اهواز', N'13590921', N'14041201', N'6', N'کارگروراننده  زباله  کش', N'', N'LJ0031', N'04', N'0', N'1', N'0', N'0', N'50358583', N'9009006145', N'100', N'', N'0', N'', N'0', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'50', N'10010', N'علي', N'پور افضل', N'اسفنديار', N'12062', N'1757057455', N'اهواز', N'اهواز', N'13670220', N'14050101', N'7', N'کارشناس  عمران', N'', N'024387', N'04', N'0', N'1', N'4', N'0', N'20201936', N'9009006145', N'', N'', N'0', N'', N'', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'43', N'10003', N'رضا', N'منيشداوي', N'رضا', N'2329', N'1757600515', N'اهواز', N'اهواز', N'13660601', N'14041101', N'4', N'کارگرپمادسازي', N'', N'1274AG', N'04', N'0', N'1', N'0', N'0', N'36719874', N'9009006145', N'100', N'', N'0', N'', N'0', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'44', N'10004', N'محمدجواد', N'جوادپور', N'قربان', N'3276', N'1882410165', N'شوشتر', N'شوشتر', N'13670119', N'14041101', N'8', N'مديرمالي  واداري', N'1', N'AW0375', N'04', N'0', N'1', N'0', N'0', N'53870685', N'9009006145', N'', N'', N'0', N'', N'09374634749', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'45', N'10005', N'حسين', N'عبيات', N'کاظم', N'13181', N'1757374000', N'اهواز', N'اهواز', N'13670607', N'14041101', N'6', N'کارگروراننده  زباله  کش', N'', N'LJ0031', N'04', N'0', N'1', N'0', N'0', N'50137949', N'9009006145', N'100', N'', N'0', N'', N'0', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'47', N'10007', N'محمد', N'خضيراوي', N'رضا', N'1741804469', N'1741804469', N'اهواز', N'اهواز', N'13730826', N'14041101', N'6', N'کارگروراننده  زباله  کش', N'', N'LJ0031', N'04', N'0', N'1', N'0', N'0', N'50186237', N'9009006145', N'100', N'', N'0', N'', N'', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'48', N'10008', N'حمزه', N'جاسمي زاده', N'عباس', N'1810396603', N'1810396603', N'آبادان', N'آبادان', N'13760106', N'14041201', N'0', N'کارگروراننده  زباله  کش', N'', N'LJ0031', N'04', N'0', N'1', N'0', N'0', N'56146913', N'9009006145', N'', N'', N'0', N'', N'', N'', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
INSERT [dbo].[tblMoarefiePersonel] ([fldRadif], [fldCodePersonel], [fldName], [fldFamily], [fldNamePedar], [fldShomareShenasname], [fldShomareMeli], [fldMahaleSodoor], [fldMahaleTavalod], [fldDateTavalod], [fldDateEstekhdam], [fldMadrak], [fldShoghl], [fldShomarePosteSazmani], [fldCodeMashaghel], [fldGorooh], [fldTaahol], [fldNoeEstekhdam], [fldVaziatePersonel], [fldOzveHeiateModire], [fldShomareBime], [fldCodeKargahi], [fldCodeMarkazhazine], [fldShomareHesab], [fldNoeHesab], [fldCodebank], [fldSarmayeSandoogh], [fldDateTark], [fldMah], [fldLock], [fldLockCode], [fldCodePosti], [fldSex], [fldShomareParvande], [fldMoarefiBedaraei], [fldNoeBime], [fldMahaleKhedmat], [fldVaziateMahaleKhedmat], [fldNoeGharardad], [fldVaziateKarmand], [fldBimeEzafekar]) VALUES (N'52', N'10006', N'امير', N'يلايي', N'محمد', N'1980325987', N'1980325987', N'دشت آزادگان', N'دشت آزادگان', N'13740120', N'14041101', N'6', N'کارگروراننده  زباله  کش', N'', N'LJ0031', N'04', N'0', N'1', N'0', N'0', N'46070745', N'9009006145', N'100', N'', N'0', N'', N'0', N'14041229', N'12', NULL, NULL, N'1111111111', N'0', N'01', N'1', NULL, N'', NULL, NULL, N'1', N'0')
GO
update tblMoarefiePersonel set fldmah='1'
GO