sql server 大全

时间:2014-05-11 08:17:55
【文件属性】:

文件名称: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'


网友评论