insert club.dbo.articles
select * from [9.1.bak].dbo.articles
where bankuai_id=1 and post_date<'2002/09/06'
select * from [9.1.bak].dbo.articles
where bankuai_id=1 and post_date<'2002/09/06'
解决方案 »
- DELETE 语句与 REFERENCE 约束"FK_lc_Card_lc_User1"冲突
- 合并2个结果集
- sql server 和数据挖掘
- 多字段表模糊查询效率问题
- 请教一个SQL语句(先到先得)
- 请教如何删除记录中重复的行,只保留一行,数据库日志恢复数据?
- 紧急求救
- How can i connect SQL SERVER by internet ?
- 如何设置id字段,使其第一条记录的默认值为G0001,随后记录中的id累加1,为G0002……
- 史上最难SQL语句--仍未完全解决
- 怎样吧SQL数据库备份到另一台机的硬上?
- 我在win2000 professional 想装sql server 2000 的服务器版,为什么装不上,说我只能装client端
再:
insert club.dbo.articles
select * from NEWCLUB.dbo.articles
where bankuai_id=1 and post_date<'2002/09/06'
select * from NEWCLUB.dbo.articles
where bankuai_id=1 and post_date<'2002/09/06'是不是如果现在存在没有删除的 是否会覆盖? 有冲突
有没有类似sql差别备份的方法?
< file_or_filegroup > [ ,...n ]
[ FROM < backup_device > [ ,...n ] ]
[ WITH
{ PARTIAL }
[ [ , ] FILE = { file_number | @file_number } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ]
[ ,...n ]
[ [ , ] NORECOVERY ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] REPLACE ]
[ [ , ] RESTRICTED_USER ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]
这是 sql手册的内容 这么复杂 那位高手能不能根据这个给出个直接用的方法?
--备份数据库日志
EXEC sp_addumpdevice 'disk', 'myclub', 'c:\club.bak'
backup log club to club with no_truncate
restore database club from disk='d:\9.1.bak' with norecovery --假定放在D盘的根目录
RESTORE LOG FROM CLUB WITH RECOVERY ,STOPAT='2002-09-05 12:00:00'
EXEC sp_addumpdevice 'disk', 'myclub', 'c:\myclub.bak'
backup log club to myclub with no_truncate
restore database club from disk='d:\9.1.bak' with norecovery --假定放在D盘的根目录
RESTORE LOG FROM myCLUB WITH RECOVERY ,STOPAT='2002-09-05 12:00:00'