在线等 答复 急
语句如下:
declare @IP varchar(50)
declare @userName varchar(50)
declare @userpwd varchar(50)
Declare @phone varchar(50)
declare @message varchar(1000)
declare @str varchar(600)
declare @DataTableName varchar(600)
declare @databaseName varchar(50)
set @IP=convert(nvarchar(50), '218.93.122.165')
set @userName =convert(nvarchar(50), 'szuser')
set @userpwd=convert(nvarchar(50), '987654321')
set @phone=convert(nvarchar(50), '18721724350')
set @message=convert(nvarchar(50), 'hello')
set @databaseName=convert(nvarchar(50), '[LightingSZ]')
set @DataTableName =convert(nvarchar(50), '[monitorsend]')
if not exists(select 1 from master.dbo.sysservers where srvname = 'srv_lnk')
begin
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB', @IP
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,@userName,@userPwd
end
set @str=N'insert srv_lnk.'+@databaseName+'.dbo.'+ @dataTableName+'(id,phonenum,smscontent) values(NEWID(),'+@phone+','+@message+')'
exec sp_executesql @str
if exists(select 1 from master.dbo.sysservers where srvname = 'srv_lnk')
begin
exec sp_dropserver 'srv_lnk','droplogins'
end
语句如下:
declare @IP varchar(50)
declare @userName varchar(50)
declare @userpwd varchar(50)
Declare @phone varchar(50)
declare @message varchar(1000)
declare @str varchar(600)
declare @DataTableName varchar(600)
declare @databaseName varchar(50)
set @IP=convert(nvarchar(50), '218.93.122.165')
set @userName =convert(nvarchar(50), 'szuser')
set @userpwd=convert(nvarchar(50), '987654321')
set @phone=convert(nvarchar(50), '18721724350')
set @message=convert(nvarchar(50), 'hello')
set @databaseName=convert(nvarchar(50), '[LightingSZ]')
set @DataTableName =convert(nvarchar(50), '[monitorsend]')
if not exists(select 1 from master.dbo.sysservers where srvname = 'srv_lnk')
begin
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB', @IP
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,@userName,@userPwd
end
set @str=N'insert srv_lnk.'+@databaseName+'.dbo.'+ @dataTableName+'(id,phonenum,smscontent) values(NEWID(),'+@phone+','+@message+')'
exec sp_executesql @str
if exists(select 1 from master.dbo.sysservers where srvname = 'srv_lnk')
begin
exec sp_dropserver 'srv_lnk','droplogins'
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货