CREATE PROCEDURE my_proc AS
declare @sql nvarchar(1000)
set @sql = N'd:\手工备份\'+convert(char(8),getDate(),112)+'bak.bak'
restore database case_boc_test from disk=@sqlGO
declare @sql nvarchar(1000)
set @sql = N'd:\手工备份\'+convert(char(8),getDate(),112)+'bak.bak'
restore database case_boc_test from disk=@sqlGO
@sql nvarchar(1000)
AS--set @sql = N'd:\手工备份\'+convert(char(8),getDate(),112+'bak.bak'
restore database case_boc_test from disk=@sql