cathyspring的博客

CAST(cast(round(a.backup_size/1024/1024,2) as numeric(5,2)) AS VARCHAR)+'MB' as backupsize,round函数：用于把数值字段舍为指定位数round(a.backup_size/1024/1024,2)即把a.backup_size/1024/1024的结果，保留2位小数cast函数：用于将round返回值，转换...

启用 xp_cmdshell 1: sp_configure 'show advanced options',1 2: reconfigure 3: GO 4: 5: sp_configure 'xp_cmdshell',1 6: reconfigure 7: go 8: BCP测试 1: 2: --建立文件夹 3: DECLARE @CmdLine ...