SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GOCREATE PROCEDURE sp_usernote AS
delete hl95.dbo.sxxx_zncust
insert into hl95.dbo.sxxx_zncust select * from openrowset
('SQLOLEDB','211.136.84.33';'yinpeng';'yp1234','select * from hlmsg.dbo.[sxxx_zncust]')
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
GO
SET ANSI_NULLS OFF
GOCREATE PROCEDURE sp_usernote AS
delete hl95.dbo.sxxx_zncust
insert into hl95.dbo.sxxx_zncust select * from openrowset
('SQLOLEDB','211.136.84.33';'yinpeng';'yp1234','select * from hlmsg.dbo.[sxxx_zncust]')
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货