ʹÓÃ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"ʾÀý£º
¡¡¡¡×ݱí½á¹¹:
¡¡¡¡
¡¡¡¡fname ftype fvalue
¡¡¡¡Ð¡ÇÇ zaocan 10
¡¡¡¡Ð¡ÇÇ zhongcan 20
¡¡¡¡Ð¡ÇÇ wancan 5
¡¡¡¡
¡¡¡¡×ª»»ºóµÄ±í½á¹¹:
¡¡¡¡
¡¡¡¡fname zaocan_value zhongcan_value wancan_value
¡¡¡¡Ð¡ÇÇ 10 20 5
¡¡¡¡
¡¡¡¡×ݱíתºá±íSQLʾÀý:
¡¡¡¡
¡¡¡¡select Fname, sum(case ......
×î½üÓöµ½Ò»¸öÎÊÌ⣬ÔÚ²Ù×÷SQL¸üÐÂÕË»§Óà¶îʱ£¬³£³£·¢ÏÖ¸üкóµÄÓà¶îÓëʵ¼ÊµÄ²»Ïà·û£¬ÂíÉÏÏëµ½ÁËÊDz»ÊÇ´æÔÚ²¢·¢¸üУ¬Ò»²é¹ûÈ»Èç´Ë¡£Ö®Ç°Ò²ÔøÓöµ½¹ýÕâÑùµÄÎÊÌ⣬µ±Ê±Ã»Ì«ÔÚÒ⣬ÏÖÔÚÊǽâ¾öµÄʱºòÁË¡£ÓÃMysqlÄ£ÄâÁËÒ»ÏÂÕâ¸ö¹ý³Ì£º´´½¨Á½ÕÅ±í£¬paralltableºÍparallalter£¬Ã¿´Î¸ù¾Ýparatable±í¸üÐÂparallalte ......
excelµ¼ÈëSQLʱÌáʾ"Êý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó"
ÒÔÏÂÄÚÈÝת×Ô[CSDN]
×î½ü´¦ÀíexcelÊý¾Ýµ¼Èëµ½Sql ServerÖУ¬Ê§°Ü£¬±¨´íÈçÏ £º
×÷ΪԴÁÐ3£¨“²úƷ˵Ã÷”£©µÄÊý¾Ý¶ÔÓÚËùÖ¸¶¨µÄ»º³åÇøÀ´½²Ì«´ó ¡£
ÎÒµÄexcelÎļþÖÐÓÐÒ»ÁнГ²úƷ˵Ã÷”£¬¾ÍÊÇһЩÎÄ×Ö¡£Sql
server´¦Àíµ¼excelÊý¾ ......
»ù±¾ÉϾÍÊÇÕâЩ²½Ö裺
ÏÂÔØÄãÒªÁ¬½ÓµÄÊý¾Ý¿âµÄJDBCÇý¶¯³ÌÐò£¨driver£©¡£Í¨³£¶¼ÊÇÒ»¸öjarÎļþ£¬¸´ÖƵ½ÄãµÄprojectÀïÃæ£¬È·±£Ê¶±ðÕâ¸ö¿â¾Í¿ÉÒÔÁË¡£
¼ÓÔØÇý¶¯£¬ ²»Í¬µÄÊý¾Ý¿âÐèÒª²»Í¬ JDBC driver¡£
Á¬½ÓÊý¾Ý¿â£¬²»Í¬µÄÊý¾Ý¿âͬÑùÐèÒª²»Í¬µÄJDBC URL¡£
ÏÂÃæ¸ø³öÁ¬½Ó²»Í¬Êý¾Ý¿âµÄÀý×Ó
Á¬½Ó mini SQL
// Establish a ......