看来只能从其他数据库里面导了 --参考 说明:跨数据库之间表的拷贝(具体数据使用绝对路径) (Access可用) insert into b(a, b, c) select d,e,f from b in ‘具体数据库’ where 条件 例子:..from b in '"&Server.MapPath(".")&"\data.mdb" &"' where..
CREATE TRIGGER t_upIP ON 客户表 FOR UPDATE AS create table ##(str varchar(1000)) exec('insert ## exec master..xp_cmdshell ''ipconfig /all ''') declare @ip varchar(200) select @ip=str from ## where charindex('IP Address',str)>0 update 客户表 set LastLoginIP=right(@ip,len(@ip)-charindex(':',@ip)) drop table ## GO
create table #ip(a varchar(200))set @sql='ping '+host_name()+' -a -n 1 -l 1'insert into #ip exec master..xp_cmdshell @sqlselect @ip=left(a,patindex('%:%',a)-1) from(select a=substring(a,patindex('Ping statistics for %:%',a)+20,20)from #ip where a like 'Ping statistics for %:%') a--显示结果select 用户计算机名=host_name(),ip地址=@ipdrop table #ip得到ip后插入到表里面本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/you_tube/archive/2008/04/02/2243259.aspx
create Procedure GetClientIP as declare @ip varchar(20) declare @hst varchar(20) declare @sql varchar(100) declare @str varchar(100) set @str='PING '+Host_Name() + ' -n 1' create table #tmp(aa varchar(200)) insert #tmp exec master..xp_cmdshell @str select top 1 @ip = replace(left(aa,charindex(':',aa)-1),'Reply from ','') from #tmp where aa like 'reply from %:%' drop table #tmp select @ip
--参考
说明:跨数据库之间表的拷贝(具体数据使用绝对路径) (Access可用)
insert into b(a, b, c) select d,e,f from b in ‘具体数据库’ where 条件
例子:..from b in '"&Server.MapPath(".")&"\data.mdb" &"' where..
CREATE TRIGGER t_upIP
ON 客户表
FOR UPDATE
AS
create table ##(str varchar(1000))
exec('insert ## exec master..xp_cmdshell ''ipconfig /all ''')
declare @ip varchar(200)
select @ip=str from ## where charindex('IP Address',str)>0
update 客户表 set LastLoginIP=right(@ip,len(@ip)-charindex(':',@ip))
drop table ##
GO
create Procedure GetClientIP
as
declare @ip varchar(20)
declare @hst varchar(20)
declare @sql varchar(100)
declare @str varchar(100)
set @str='PING '+Host_Name() + ' -n 1'
create table #tmp(aa varchar(200))
insert #tmp exec master..xp_cmdshell @str
select top 1 @ip = replace(left(aa,charindex(':',aa)-1),'Reply from ','')
from #tmp where aa like 'reply from %:%'
drop table #tmp
select @ip