ARR Asked: 2020-01-29 09:02:43 +0800 CST 2020-01-29 09:02:43 +0800 CST 2020-01-29 09:02:43 +0800 CST Update information from one column to another in SQL Server 2012 772 I have the following query: SELECT NUM_EMP_SEP, NUM_EMP_OCT FROM CONTADOR WHERE NUM_EMP_OCT IS NOT NULL The result is: I need the same information that is in the column NUM_EMP_OCTto be copied to the columnNUM_EMP_SEP sql-server-2012 1 Answers Voted Best Answer Patricio Moracho 2020-01-29T09:05:17+08:002020-01-29T09:05:17+08:00 You can do it with an update statement: UPDATE CONTADOR SET NUM_EMP_SEP = NUM_EMP_OCT WHERE NUM_EMP_OCT IS NOT NULL
You can do it with an update statement: