写存储过程实现,类似于这种if exists(select * from sysobjects where name ='proc_cardinf2o')
drop proc proc_cardinfo2
go
create proc proc_cardinfo2
@id varchar(20)
as
declare @money money,@custid int
select @money=LeftMoney form CardInfo where CardId =@id
select @custid=CustId from CardInfo where CardId =@id
print '该帐户余额为:'+convert (varchar(10),@money)+'数据正在读取,请稍候'
delete from AccountInfo where CardId =@id--删除帐户信息
delete from CardInfo where CardId =@id--删除银行卡信息
delete from TransInfo where CustId=@custid
go
exec proc_cardinfo2 '9559 4211 1256 8960'
drop proc proc_cardinfo2
go
create proc proc_cardinfo2
@id varchar(20)
as
declare @money money,@custid int
select @money=LeftMoney form CardInfo where CardId =@id
select @custid=CustId from CardInfo where CardId =@id
print '该帐户余额为:'+convert (varchar(10),@money)+'数据正在读取,请稍候'
delete from AccountInfo where CardId =@id--删除帐户信息
delete from CardInfo where CardId =@id--删除银行卡信息
delete from TransInfo where CustId=@custid
go
exec proc_cardinfo2 '9559 4211 1256 8960'
BACKUP DATABASE text
to disk='c:\11.bak' with init还原
RESTORE DATABASE CDJTLZGIS
FROM DISK = 'c:\33.bak'
WITH MOVE 'CDJTLZGIS_Data' TO 'c:\CDJTLZGIS_Data',
MOVE 'CDJTLZGIS_Log' TO 'c:\CDJTLZGIS_Log'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\testdb.ldf'
BACKUP DATABASE text
to disk='c:\11.bak' with init还原
RESTORE DATABASE CDJTLZGIS
FROM DISK = 'c:\33.bak'
WITH MOVE 'CDJTLZGIS_Data' TO 'c:\CDJTLZGIS_Data',
MOVE 'CDJTLZGIS_Log' TO 'c:\CDJTLZGIS_Log'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\testdb.ldf'
不是这种方式备份 是备份的时候会新建一个表