文件名称:sql server 大全
文件大小:4KB
文件格式:TXT
更新时间:2014-05-11 08:17:55
sql
update b01 set dept_code=dept_code where 1=2 declare @BakFileName char(100),@BakTime char(100) Set @BakTime=convert(char(8),getdate(),8) Set @BakTime='-'+SubString(@BakTime,1,2)+SubString(@BakTime,4,2)+SubString(@BakTime,7,2) set @BakFileName='D:\SqlData\bak\8i\8iDemo-'+convert(char(6),getdate(),12)+@baktime+'.bak' backup database V9demo to disk=@BakfileName with description='backup by MyHR'