iteye_8185的博客

经典SQL语句大全 一、基础 1、说明：创建数据库 CREATE DATABASE database-name 2、说明：删除数据库 drop database dbname 3、说明：备份sql server --- 创建 备份数据的 device USE master EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7ba...

select ISNULL(cast(year(birthdate) as VARchar(10)) +'-'+cast(month(birthdate) as VARchar(10)) +'-'+cast(day(birthdate) as VARchar(10)) ,'日期不详') as 日期 from employees; select cast(year(getdate(...

update table1 set table1.name=table2.name from table1,table2 where table1.id=table2.id