In this blog I will show how to use Join with Update command in SQL. I had a situation where I had to update the column of a table with the values from other table for all the employees simultaneously. There were 2 tables. a) Emp_Info table which contains a record of all employees like EmpID, EmpName, EmpAddress,EmpAge,TotalSalary. b) EmpSalary table which contains the salary for each mo...
It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.
enter your email address:
What kind of email newsletter would you prefer to receive from CodeAsp.Net?18
