[login]
UserCode=admin
[copy]
copy=Insert into titem(fcode,fname,fdesc,fdate_finish,fitemid,fitemcode,fitemname,fitemdesc,fitemcolor,fitemunit,fqty,fisbproduce,fisbdate,fismcontrol,fisfinish,fisfdate,fispcontrol,fbill_user,fbill_date) Values('asdfdsa','SC2005100014',NULL,'2005.10.12','349','12011-102601','無錫60S絲光紗','','12011','kg','3434',1,NULL,NULL,0,NULL,NULL,NULL,NULL)
[RestoreDatabase]
RestoreDB=use Master ALTER DATABASE aaa set offline with rollback immediate 
 RESTORE DATABASE aaa FROM DISK ='G:\leaders\sqldata\creativejxc'
 with file=1,replace, 
MOVE 'creativejxc_data' TO 'G:\leaders\Data\aaa_creative_data.mdf',
MOVE 'creativejxc_Log' TO 'G:\leaders\Data\aaa_creative_log.ldf'
 alter database aaa set online with rollback immediate 
 Use aaa
 
 RESTORE DATABASE leaderjxc FROM DISK ='D:\leaders\sqldata\creativejxc'
 with file=1,replace, 
MOVE 'creativejxc_data' TO 'D:\leaders\Data\leaderjxc_creative_data.mdf',
MOVE 'creativejxc_Log' TO 'D:\leaders\Data\leaderjxc_creative_log.ldf'
 alter database leaderjxc set online with rollback immediate 
 Use leaderjxc