backstr:='RESTORE DATABASE reg FROM DISK ='''+extractfilepath(application.Exename)+'reg.dat'+''''+' WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY , '+
'MOVE N'+''''+'reg_Data'+''''+' TO N'+''''+'D:\reg_Data.mdf'+''''+', MOVE N'+''''+'reg_Log'+''''+' TO N'+''''+'D:\reg_log.ldf'+'''';我想将上面还原的目录(d:\)用如下来@path替换
declare @path varchar(200)
select @path = filename from master.dbo.sysfiles
set @path = ltrim(REVERSE(@path))
---------------------------------------------------------------------
set @path = REVERSE(substring(@path,CHARINDEX('\',@path),len(@path)))
------------------------------------------------------------------------
这条SQL语如何写。。我写就是出错。。单引号打得不对。。
adoquery1.sql.add( 一 )
adoquery1.sql.add(backstr)
注意:----------内的\线如何写。。放到一中 ,backstr 中的目录用@path 换下,如何写,谢谢!!
'MOVE N'+''''+'reg_Data'+''''+' TO N'+''''+'D:\reg_Data.mdf'+''''+', MOVE N'+''''+'reg_Log'+''''+' TO N'+''''+'D:\reg_log.ldf'+'''';我想将上面还原的目录(d:\)用如下来@path替换
declare @path varchar(200)
select @path = filename from master.dbo.sysfiles
set @path = ltrim(REVERSE(@path))
---------------------------------------------------------------------
set @path = REVERSE(substring(@path,CHARINDEX('\',@path),len(@path)))
------------------------------------------------------------------------
这条SQL语如何写。。我写就是出错。。单引号打得不对。。
adoquery1.sql.add( 一 )
adoquery1.sql.add(backstr)
注意:----------内的\线如何写。。放到一中 ,backstr 中的目录用@path 换下,如何写,谢谢!!
var s:string;
begin
s:='tdfdfd''dfdfdf';
end;
如:
S:='fhkjds'+#39+'fsdf'+#39;
Select * From mytable where name='John'=>
'Select * From myTable Where Name="John"'=>
'Select * From myTable Where Name=''John'''
begin
sql.add('select * from table where field=:field');
Parameters.ParamByName('field').value :=@path;
end