sql数据库怎么实现两个数据库的数据

--同步新增的数据

insert into srv_lnk.test.dbo.[user]

select id,number,name from [user] where state is null

--同步修改的数据

update srv_lnk.test.dbo.[user] set

number=b.number,name=b.name

from srv_lnk.test.dbo.[user] a

join [user] b on a.id=b.id

where b.state=1

--同步删除的数据

delete from srv_lnk.test.dbo.[user]

where id not in(select id from [user])

你那图看着费劲

create database students

on primary

(

name=students1,

filename='d:\data\students1.mdf',

size=10MB,

filegrowth=10%,

maxsize=UNLIMITED

),

(

name=students2,

filename='d:\data\students2.ndf',

size=10MB,

filegrowth=1MB,

maxsize=75MB

)

log on

(

name=studentlog1,

filename='E:\data\studentlog1.ldf',

maxsize=10MB,

filegrowth=1MB

),

(

name=studentlog2,

filename='E:\data\studentlog2.ldf',

maxsize=10MB,

filegrowth=1MB

)

所有路径都要提前建立，d盘的data目录和E盘的data目录，其他的自己看着哪不对自己改一下吧

---