MSSQL vs ORACLE (一、SQL语法)

MSSQL恢复

backup database SR_TMDemo
to 
disk ='E:\Backup\TMDemoBackup.bak'



restore filelistonly from 
disk ='E:\Shemed_DEV\备份\0229'

restore database SR_TMDemo from 
disk = 'E:\Shemed_DEV\备份\0229'
with move 'data_hy_Data' to 'D:\SQL_Data\SR_TMDemo.mdf',
move 'data_hy_Log' to 'D:\SQL_Data\SR_TMDemo.ldf'

sp_helpuser
sp_adduser 'tm','tmuser','db_owner'
sp_addlogin 'tm', 'tmuser'

 

ORACLE函数

To_Date('2008-04-24 21:18:18', 'YYYY-MM-DD HH24:MI:SS')



convert(varchar(40), convert(datetime, '2008-04-24 21:18:18'), 20)