Skip to main content

Important SQL Query - Update From SQL


UPDATE tbl_Def_Emp_Salary
SET tbl_Def_Emp_Salary.Emp_Status = tbl_Employee.Emp_Status
FROM tbl_Employee
WHERE tbl_Def_Emp_Salary.EMP_CODE = tbl_Employee.EMP_CODE

Comments

Post a Comment

Popular posts from this blog

Spiral Model C#

I have created following: 01 - Db.Model ( i.e., "TicketProtection.cs + "ServiceCharges.cs" + "AtolProtection.cs") 02 - Configuration ( i.e., "TicketProtectionConfiguration.cs" + "ServiceChargesConfiguration.cs" + "AtolProtectionConfiguration.cs") 03 - Migration Added Migration(add-migration added_costing_charges_table)  04 - SQL Insert Script ( i.e., for ticket_protection_charges. in figure bellow)Please review if i miss anything...? 05 - Data for SQL Insert Script: creating file in seeding folder of project - with "embaded resource" 06 - Run the Project on Database to check data & tables are created. 07 - Repository: 08 - Manager ( Interface and Implementation) (Reference Data Manager) 09 - Controller (Reference Data Controller) "CustomApiResponse" 10 - Create Map in SelectItemProfile   11 - Create Front End "Costing Methods PassengerType wise" 
Post a Comment
Read more

Distribution Management Software

Inventory & Financial Management System for Distribution Business CREATE & DEFINE: Area Sale Office Customer Supplier Main Products Group Products Product Specification Chart of Account Heads Sale Office Targets MAINTAIN TRANSACTIONS & RECORDS : Sale Order Sale Invoice Sale Voucher Purchase Order Purchase Invoice Purchase Voucher Cash Received Voucher Cash Payment Voucher Bank Payment Voucher Bank Received Voucher Journal Voucher Cheque Book Record  ( Cleared & Uncleared ) REPORTS : ORDER PRINT, INVOICE PRINT, VOUCHER PRINT, INVENTORY REPORTS, ACCOUNTING REPORTS, ETC
1 comment
Read more