Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLSERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿

SQL SERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿

Ö÷ÒªÏëʵÏÖÒÔÏ£º
Ò»¸öÓû§Á¬½Óµ½Êý¾Ý¿â£¬°ÑÓû§µÄÓû§ÃûÓëIP¶¼±£´æÔÚÊý¾Ý¿âÖУ¬À´ÊµÏÖÓû§µÇ¼µÄ¹¦ÄÜ¡£
×îºÃÊÇÓû§µ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì£¬°ÑÓû§Ãû×÷²ÎÊý£¬´æ´¢¹ý³Ì¾ÍÄܰÑÓû§µÄÓû§ÃûÓëIP±£´æÏÂÀ´¡£

ÇëÖ¸½Ì£¨Ö»ÓÐ16·ÖÁË£©
SQL code:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_getlinkinfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_getlinkinfo]
GO

/*--»ñÈ¡Á¬½ÓSQL·þÎñÆ÷µÄÐÅÏ¢

ËùÓÐÁ¬½Ó±¾»úµÄ:²Ù×÷µÄÊý¾Ý¿âÃû,¼ÆËã»úÃû,Óû§Ãû,Íø¿¨ÎïÀíµØÖ·,IPµØÖ·,³ÌÐòÃû
--×Þ½¨ 2003.11--*/

/*--µ÷ÓÃʾÀý
--ÏÔʾËùÓб¾»úµÄÁ¬½ÓÐÅÏ¢
exec p_getlinkinfo

--ÏÔʾËùÓб¾»úµÄÁ¬½ÓÐÅÏ¢,°üº¬ipµØÖ·
exec p_getlinkinfo @includeip=1

--ÏÔʾÁ¬½ÓÖ¸¶¨Êý¾Ý¿âµÄÐÅÏ¢
exec p_getlinkinfo '¿Í»§×ÊÁÏ'
--*/
create proc p_getlinkinfo
@dbname sysname=null, --Òª²éѯµÄÊý¾Ý¿âÃû,ĬÈϲéѯËùÓÐÊý¾Ý¿âµÄÁ¬½ÓÐÅÏ¢
@includeip bit=0 --ÊÇ·ñÏÔʾIPµØÖ·,ÒòΪ²éѯIPµØÖ·±È½Ï·Ñʱ,ËùÒÔÔö¼Ó´Ë¿ØÖÆ
as
declare @dbid int
set @dbid=db_id(@dbname)

create table #tb(id int identity(1,1),dbname sysname,hostname nchar(128),loginname nchar(128),net_address nchar(12),net_ip nvarchar(15),prog_name nchar(128))


Ïà¹ØÎÊ´ð£º

jsp jdbcÁ¬½Ósqlserver 2000 ³öÏÖÎÊÌâ

´úÂ룺

try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......

vfpÈçºÎ¶ÁÈ¡SQLServer×Ö¶ÎÖеÄͼƬ£¿

ÔõôÔÚvfpµÄ±íµ¥ÖÐÏÔÏÖ´ÓsqlserverÖÐ×¥¹ýÀ´µÄͼƬ£¿

ÎÒÓõÄÊÇvfp6.0

Ìý˵¿ÉÒÔµ÷ÓÃÆäËûÓïÑÔдµÄdllÀ´ÊµÏÖ£¬
ÎÒ¿ÉÒÔÓÃdelphiдdll³öÀ´£¬
µ«ÊÇÎÒ²»»áÓÃʹÓÃvfpÀ´µ÷ÓÃdll°¡

Õâ¶Î´úÂëÊÇ´ÓSQLSEREVR¡¡I ......

sqlserver¡¡µÄ¹æÔòruleÈçºÎÀí½â

sqlserver¡¡µÄ¹æÔòruleÈçºÎÀí½â£¬¡¡ÏÂÃæÊÇÒ»¸öʵÀý£¬Çë½áºÏ¸ÃÀý×Ó½âÊÍ£º
ΪĿ±êÊý¾Ý¿â¹ÜÀíϵͳÉè¼ÆÒµÎñ¹æÔò£º
4.2.1 ¹æÔò£º
Ø rule[Sex]
create rule [Sex] as @ in ('ÄÐ','Å®') ......

sqlserver jdbc driverÇý¶¯ÄÄÀïÕÒ

ÎÒ´Ó΢Èí¹ÙÍøÏÂÔØµÄdriverÔõôÊǸöhtmlÎļþË­¸øÖ¸Õýһϣ¬ÔÚÄÄÀïÏ£¬¾ßÌå·¾¶¼°²Ù×÷²½Öè
Ò»°ã¹ÜÍøÏÂÔØ¶¼ÒªÒ»²½Ò»²½×ßÏÂÈ¥£¬Èç¹ûÄã¹ýÔçÁí´æÎªµÄ»°£¬µÃµ½µÄÍùÍùÊÇlicenseÄÇÒ»Ò³¡£

ÎҼǵĺÃÏëÔÚ£ºÄãϵÄÄǸöHTMLÎļ ......

Óг¥ÇósqlserverÊý¾Ý¿âÉè¼Æ:ÓÐÏßµçÊÓ

ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ

Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ­½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ