CREATE PROCEDURE CopyData asDECLARE @srv_link char(20) set @srv_link='192.168.0.2' exec sp_addlinkedserver @srv_link,'','SQLOLEDB','192.168.0.2' exec sp_addlinkedsrvlogin @srv_link,'false',null,'wzs','wzs' exec ('insert into Article_tbl select * from [' + @srv_link + '].wztj.dbo.Article_tbl where a_outnet_i=1'); exec('update [' + @srv_link + '].wztj.dbo.Article_tbl set a_outnet_i=2 where a_outnet_i=1');exec sp_dropserver @srv_link,'droplogins' GO上面是存储过程代码作业调用 set ansi_nulls on set ansi_warnings onexec CopyData set ansi_nulls off set ansi_warnings off
asDECLARE @srv_link char(20)
set @srv_link='192.168.0.2'
exec sp_addlinkedserver @srv_link,'','SQLOLEDB','192.168.0.2'
exec sp_addlinkedsrvlogin @srv_link,'false',null,'wzs','wzs'
exec ('insert into Article_tbl select * from [' + @srv_link + '].wztj.dbo.Article_tbl where a_outnet_i=1');
exec('update [' + @srv_link + '].wztj.dbo.Article_tbl set a_outnet_i=2 where a_outnet_i=1');exec sp_dropserver @srv_link,'droplogins'
GO上面是存储过程代码作业调用
set ansi_nulls on
set ansi_warnings onexec CopyData
set ansi_nulls off
set ansi_warnings off
加了 数据库名.dbo.也不能执行!!是不是在程序中进行了没有提交的数据操作?
这是什么意思?