Last post Jan 02, 2015 06:28 AM by mdehghani
Jan 01, 2015 05:24 AM|mdehghani|LINK
I'm trying to rename a table column name by making a copy and deleting the old one.. I've made the new column but cant copy the information from the old one..
I came across this sql statement but don't know how to apply it in practice...
Update MyTable SET MyNewColumn = MyOldColumn
can anyone give an example?
my database name is Azmoon
old column name: BarExamName
new column name: Name
Jan 01, 2015 06:13 AM|Mikesdotnetting|LINK
UPDATE BarExams SET [Name] = BarExamName
Jan 02, 2015 06:28 AM|mdehghani|LINK
thanks a lot sir!