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
stackoverflow-54876809-trying-to-get-an-xml-file-into-sql-table
Loading json file into sql server
samplequery
BRYAN_BD1
non_numeric_table
Project 1
Unpivot Example
FIGURA5.4
Ejercicios de SQL (I)9
9.12.2020