COMPONENTE IDEAL PARA RODAR SCRIPT DE SQL SERVER!!!!!!!!!!!!
12/03/2003
0
e ai galera, beleza?
seguinte... tenho o seguinte script abaixo, e gostaria de saber qual o componente de delphi ideal para colocá-lo... existe algum componente especifico para scripts de sql server? como faço para usá-lo?
set nocount on declare @backupfile varchar(250), @sql nvarchar(1000),@parm nvarchar(100), @resultD nvarchar(100), @resultL nvarchar(100)
set @backupfile=´c:\infopae\database\bckinst.bck´
set @sql=´restore filelistonly from disk = ´´´ + @backupfile + ´´´ ´
create table #t1( logicalname sysname, physicalname varchar(250), type char(1), filegroupname varchar(50) NULL, size float, maxsize float)
insert into t1 exec (@sql)
select @resultD = logicalname from t1 where type = ´D´
select @resultL = logicalname from t1 where type = ´L´
CREATE DATABASE GUAMARE
RESTORE DATABASE GUAMARE
FROM DISK =´c:\infopae\database\bckinst.bck´
WITH REPLACE,
MOVE @resultD TO ´c:\infopae\database\GUAMARE_data.mdf´,
MOVE @resultL TO ´c:\infopae\database\GUAMARE_log.ldf´
DROP TABLE #t1
set nocount on declare @backupfile varchar(250), @sql nvarchar(1000),@parm nvarchar(100), @resultD nvarchar(100), @resultL nvarchar(100) set @backupfile=´$DESTINO/$NOMEREF.bck´ set @sql=´restore filelistonly from disk = ´´´ + @backupfile + ´´´ ´ create table t1( logicalname sysname, physicalname varchar(250), type char(1), filegroupname varchar(50) NULL, size float, maxsize float) insert into t1 exec (@sql) select @resultD = logicalname from t1 where type = ´D´ select @resultL = logicalname from t1 where type = ´L´ CREATE DATABASE $NOMEREF RESTORE DATABASE $NOMEREF FROM DISK =´$DESTINO/$NOMEREF.bck´ WITH REPLACE, MOVE @resultD TO ´c:\infopae\database\$NOMEREF_data.mdf´, MOVE @resultL TO ´c:\infopae\database\$NOMEREF_log.ldf´ DROP TABLE t1
seguinte... tenho o seguinte script abaixo, e gostaria de saber qual o componente de delphi ideal para colocá-lo... existe algum componente especifico para scripts de sql server? como faço para usá-lo?
set nocount on declare @backupfile varchar(250), @sql nvarchar(1000),@parm nvarchar(100), @resultD nvarchar(100), @resultL nvarchar(100)
set @backupfile=´c:\infopae\database\bckinst.bck´
set @sql=´restore filelistonly from disk = ´´´ + @backupfile + ´´´ ´
create table #t1( logicalname sysname, physicalname varchar(250), type char(1), filegroupname varchar(50) NULL, size float, maxsize float)
insert into t1 exec (@sql)
select @resultD = logicalname from t1 where type = ´D´
select @resultL = logicalname from t1 where type = ´L´
CREATE DATABASE GUAMARE
RESTORE DATABASE GUAMARE
FROM DISK =´c:\infopae\database\bckinst.bck´
WITH REPLACE,
MOVE @resultD TO ´c:\infopae\database\GUAMARE_data.mdf´,
MOVE @resultL TO ´c:\infopae\database\GUAMARE_log.ldf´
DROP TABLE #t1
set nocount on declare @backupfile varchar(250), @sql nvarchar(1000),@parm nvarchar(100), @resultD nvarchar(100), @resultL nvarchar(100) set @backupfile=´$DESTINO/$NOMEREF.bck´ set @sql=´restore filelistonly from disk = ´´´ + @backupfile + ´´´ ´ create table t1( logicalname sysname, physicalname varchar(250), type char(1), filegroupname varchar(50) NULL, size float, maxsize float) insert into t1 exec (@sql) select @resultD = logicalname from t1 where type = ´D´ select @resultL = logicalname from t1 where type = ´L´ CREATE DATABASE $NOMEREF RESTORE DATABASE $NOMEREF FROM DISK =´$DESTINO/$NOMEREF.bck´ WITH REPLACE, MOVE @resultD TO ´c:\infopae\database\$NOMEREF_data.mdf´, MOVE @resultL TO ´c:\infopae\database\$NOMEREF_log.ldf´ DROP TABLE t1
Raonepn
Curtir tópico
+ 0
Responder
Clique aqui para fazer login e interagir na Comunidade :)