T-SQL % 取餘數，動態備份至不同磁碟

<br /><br />declare @a datetime<br />set @a = getdate()<br /><br />if (day(@a) % 2) = 0<br />begin<br />exec databasebackup 'friend','d:\db.dmp'<br />end<br /><br />if (day(@a) % 2) = 1<br />begin<br />exec databasebackup 'friend','f:\db.dmp'<br />end<br />