进来看一下,顶着有分,告急

[lzgvcd]

CREATE PROCEDURE dt_backupdata AS
declare @backdate datetime
select backdate=getdate()
backup database 电阻测量 to disk='d:\back\back' + cast (@backdate as varchar)---------------------------
Microsoft SQL-DMO （ODBC SQLState: 42000）
---------------------------
错误 170: 第 4 行: '+' 附近有语法错误。
---------------------------
确定
---------------------------
老是提示这样,请指点菜鸟

[lzgvcd]

declare @backdate varchar
declare @backmonth varchar
declare @backday varchar
declare @backdisk varchar(100)
select @backdate=cast(datepart(yyyy,getdate()) as varchar)
select @backmonth=cast(datepart(mm,getdate()) as varchar)
select @backday=cast(datepart(dd,getdate()) as varchar)
select @backdisk='d:\back\back'+@backdate +@backmonth+@backday
select @backdisk

[lzgvcd]

这个是正确的结果,刚才没有把变量的标志加上,不好意思,谢谢大家了

[老宛]

要用动态语句，用exec来执行

[Limperator]

backup database 电阻测量 to disk='d:\back\back' + convert(varchar(8), getdate(), 112) + replace(convert(varchar(12), getdate(), 114), ':', '')

[Rotaxe]

CREATE PROCEDURE dt_backupdata AS
declare @backdate datetime
declare @sql varchar(1000)
select @backdate=getdate()
select @sql='backup database 电阻测量 to disk=''d:\back\back''' + cast (@backdate as varchar)
exec(@sql)

[Limperator]

EXEC 执行上面的语句

[lzgvcd]

这个必须要这样写吗?(to 程序员)

[greating]

CREATE PROCEDURE dt_backupdata1 AS
declare @backdate datetime
declare @back_disk varchar
select backdate=getdate()
select back_disk='d:\jserp\'+cast(@backdate as varchar)
backup database dberp to disk=@back_disk---------------------------

[lzgvcd]

还是不行

[lzgvcd]

declare @backdate varchar
declare @backmonth varchar
declare @backday varchar
declare @backdisk varchar
select backdate=cast(datepart(yyyy,getdate()) as varchar)
select backmonth=cast(datepart(mm,getdate()) as varchar)
select backday=cast(datepart(dd,getdate()) as varchar)
select backdisk='d:\back\back'+@backdate +@backmonth+@backday
backup database 电阻测量 to disk=@backdisk
backdisk的结果为null这个是什么原因?

[zheninchangjiang]

declare @backdate varchar
declare @backmonth varchar
declare @backday varchar
declare @backdisk varchar
select @backdate=cast(datepart(yyyy,getdate()) as varchar)
select @backmonth=cast(datepart(mm,getdate()) as varchar)
select @backday=cast(datepart(dd,getdate()) as varchar)
select @backdisk='d:\back\back'+@backdate +@backmonth+@backday --少了变量前缀就成了一个查询而不是赋值了
backup database 电阻测量 to disk=@backdisk
backdisk的结果为null这个是什么原因?

[rezood]

我也不懂！高手教教啊！！！