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)