Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Rename column name using 'sp_rename' command
CREATE TABLE Sales (EmpId INT, Yr INT, price MONEY) INSERT Sales VALUES(1, 2005, 12000) INSERT Sales VALUES(1, 2006, 18000) INSERT Sales VALUES(1, 2007, 25000) INSERT Sales VALUES(2, 2005, 15000) INSERT Sales VALUES(2, 2006, 6000) INSERT Sales VALUES(3, 2006, 20000) INSERT Sales VALUES(3, 2007, 24000) execute sp_rename 'Sales.Yr','Year','COLUMN' select * from Sales
run
|
edit
|
history
|
help
0
robot-grading
SQL_DS_collections
customers
Marco - Arvind
mywall
aawrish
Terceiro
comparison and logical
db3
Update using a temp table