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

ʹÓÃT SQL»ñÈ¡µ½SQLServer IpºÍ¶Ë¿ÚºÅ

ÔÚÆ½Ê±µÄ¹¤×÷¹ý³ÌÖУ¬×÷ΪDBA½ÇÉ«¹ÜÀíÊý¾Ý¿â£¬Í·ÄÔÖеÄÓ¡ÏóÍùÍùÊÇÊý¾Ý¿âʵÀýÃû³Æ£¬¶ø²»»áÈ¥¹ØÐÄServerµÄIP£¬¶ø×÷ΪDeveloperµÄ½ÇÉ«£¬ËûÃÇÍùÍùÏëÖªµÀÖªµÀServer IpºÍ¶Ë¿ÚºÅ¡£ËùÒÔ£¬DBA»á¾­³£±»Îʼ°µ½£ºXXXʵÀýµÄIPºÍ¶Ë¿ÚºÅÊÇʲô£¿
Õâ¸öÎÊÌ⣬µ±È»ÎÒÃÇ¿ÉÒÔLoginµ½OS²é¿´IP¡¢Ê¹ÓÃÅäÖÆ¹ÜÀí¹¤¾ß»ñÈ¡µ½¶Ë¿ÚºÅ¡£µ«ÊÇ£¬Õâ¸ö·½·¨·Ç³£µÄÂé·³£¬´ï²»µ½DBA¸ßЧ¿ìËÙ·´Ó¦µÄÒªÇó¡£
ÄÇô£¬ÕâÆªÎÄÕ¾ÍÊÇΪÁ˽â¾öЧÂÊÎÊÌ⣬ʹÓÃÏÂÃæµÄSQL Script¿ÉÒÔÇáËɵĻñÈ¡µ½SQLServer IpºÍ¶Ë¿ÚºÅ¡£
 
USE master 
GO
DECLARE @tcpEndport VARCHAR(20)
        ,@regeditKey VARCHAR(100)
 
 
 
/**Enable xp_cmdshell
 
EXEC sp_configure 'show advanced options', 1 
RECONFIGURE WITH OVERRIDE
 
EXEC sp_configure 'xp_cmdshell', 1 
RECONFIGURE WITH OVERRIDE 
**/
 
--SQLServer 2000
IF @@VERSION LIKE 'Microsoft SQL Server  2000%'--SQLServer 2000
BEGIN
    SET @regeditKey= N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp'
    EXEC  master.dbo.xp_regread  
                @rootkey='HKEY_LOCAL_MACHINE'  
                 ,@key= @regeditKey
                 ,@value_name='TcpPort'  
                 ,@value=@tcpEndport   OUTPUT
END
/*
SQLServer 2005 and SQLServer 2008
*/
ELSE
BEGIN
    IF @@Servicename='MSSQLSERVER'--Default instance
    BEGIN
        SET @regeditKey='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp'
    END
    ELSE
    BEGIN
        SET @regedi


Ïà¹ØÎĵµ£º

ÎÒµÄSQL֮·2

   ÖÁ½ñδÓгɾͣ¬Éõ¸ÐáÝáå¡£
   ²¢²»ÊǺÜͻȻµÄÏëѧSQL£¬¶øÊÇÔÚ֮ǰ˵µÄÄÇÑù£¬ÔÚÎÒÈÆÁËÒ»´óȦ֮ºó£¬²ÅÖªµÀ×Ô¼ºÒ²ÊÇÒ»ÎÞËùÖª£¬Í÷ѧÁËÕâô¶àÄê¡£
   ÎÒÒ»Ö±ÏëÍÑÀëѧУµÄ½ÌÓýģʽÀ´×Ôѧ£¬È»¶øÎÒ²¢²»³ÐÈÏѧУµÄ½ÌÓý·½Ê½ÊÇÒ»ÎÞËùÓõģ¬ÖÁÉÙѧµ½µÄ¶«Î÷ÊÇʵÔڵġ£´ÓѧУµÄ½Ç¶ÈÀ´¿¼ÂÇ£¬ ......

ʹÓÃSQLÓï¾äÉú³ÉÊý¾Ý×Öµä

--sqlserver 2000
SELECT ±íÃû=case when a.colorder=1 then d.name else '' end,
--×Ö¶ÎÐòºÅ=a.colorder,
×Ö¶ÎÃû=a.name,
--
±êʶ=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,
/**/
Ö÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and name
in ( ......

ÌÖÂÛ ²¢·¢Ö´ÐÐSQLʱµÄ¸üжªÊ§£¬ÈçºÎ½â¾öÕâÖÖÎÊÌâ

    ×î½üÓöµ½Ò»¸öÎÊÌ⣬ÔÚ²Ù×÷SQL¸üÐÂÕË»§Óà¶îʱ£¬³£³£·¢ÏÖ¸üкóµÄÓà¶îÓëʵ¼ÊµÄ²»Ïà·û£¬ÂíÉÏÏëµ½ÁËÊDz»ÊÇ´æÔÚ²¢·¢¸üУ¬Ò»²é¹ûÈ»Èç´Ë¡£Ö®Ç°Ò²ÔøÓöµ½¹ýÕâÑùµÄÎÊÌ⣬µ±Ê±Ã»Ì«ÔÚÒ⣬ÏÖÔÚÊǽâ¾öµÄʱºòÁË¡£ÓÃMysqlÄ£ÄâÁËÒ»ÏÂÕâ¸ö¹ý³Ì£º´´½¨Á½ÕÅ±í£¬paralltableºÍparallalter£¬Ã¿´Î¸ù¾Ýparatable±í¸üÐÂparallalte ......

excelµ¼ÈëSQLʱÌáʾ"Êý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó"


excelµ¼ÈëSQLʱÌáʾ"Êý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó"
ÒÔÏÂÄÚÈÝת×Ô[CSDN]
×î½ü´¦ÀíexcelÊý¾Ýµ¼Èëµ½Sql ServerÖУ¬Ê§°Ü£¬±¨´íÈçÏ £º
×÷ΪԴÁÐ3£¨“²úƷ˵Ã÷”£©µÄÊý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó ¡£
ÎÒµÄexcelÎļþÖÐÓÐÒ»ÁнГ²úƷ˵Ã÷”£¬¾ÍÊÇһЩÎÄ×Ö¡£Sql
server´¦Àíµ¼excelÊý¾ ......

sqlserver²éѯ£¨Ê±¼äÏà¹Ø£©

select a.UserName Óû§Ãû,b.LoginName ºÅÂë,c.MenuTitle ±êÌâ,max(a.AccessTime)·ÃÎÊʱ¼ä  from JfAccessLog a,OaUser b,JfMenu c where CONVERT(char,a.AccessTime,112)=CONVERT(char,GETDATE(),112)  and a.UserId=b.UserId and a.MenuId=c.MenuId and a.MenuId=@menu group by a.UserName,b.LoginName,c.Menu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ