Sql Server Êý¾Ý¿âÁ¬½ÓÎÊÌâ
²Î¿¼ÎÄÏ×£ºhttp://www.cnblogs.com/chenxizhang/archive/2009/04/23/1441913.html
SQL ServerÌṩËÄÖÖ·½Ê½Á¬½ÓÊý¾Ý¿â·þÎñÆ÷:
1. share memory: Ö»ÊÊÓÃÓÚ¿Í»§¶ËºÍ·þÎñÆ÷¶ËÔÚͬһ̨»úÆ÷ÉÏ,²ÅÄܲÉÓõÄÁ¬½Ó
2. Named pipe:
ÔÚ¾ÖÓòÍø(LAN)ÄÚʵÏÖÁ¬½Ó,Ò»¸ö½ø³ÌʹÓÃÒ»²¿·ÖµÄÄÚ´æÀ´Ïò½ø³ÌµÄÁíÒ»¶Ë´«µÝÏûÏ¢,Ò»¸ö½ø³ÌµÄÊä³öÊÇÁíÍâÒ»¸ö½ø³ÌµÄÊäÈë.
3. TCP/IP: ÒòÌØÍøÉÏʹÓÃ,¿ÉÒÔÓÃÓÚ²»Í¬µÄÓ²¼þÌåϵ½á¹¹ºÍ²Ù×÷ϵͳµÄ¼ÆËã»úÍøÂçÖ®¼ä½øÐÐͨÐÅ(¶Ë¿ÚºÅ)
4. VIA:ÐéÄâ½Ó¿ÚÊÊÅäÆ÷£¬ÓëÒ»ÖÖÌض¨Ó²¼þÒ»ÆðʹÓõÄרÃÅ»¯µÄÐÒ飬ÖÁ½ñûÓÐÓùý¡£¡£¡£¡£
µ±ÎÒÃÇʹÓÿͻ§¶ËÃüÁîÐй¤¾ßÈçsqlcmd.exe½øÐзÃÎÊʱ£¬²ÉÓÃÈçϵÄ˳Ðò½øÐнâÎö£º
Ê×ÏÈ£¬»áʹÓÃsqlcmd.exe ÃüÁîÐй¤¾ßÊäÈëµÄÁ¬½Ó×Ö·û´®ËùÃèÊöµÄÐÒé½øÐÐÁ¬½Ó
Æä´Î£¬Èç¹ûÔÚsqlcmd.exeÃüÁîÐÐûÓÐÃèÊöÓйصÄÐÒ飬Ôò²ì¿´¿Í»§¶ËÅäÖùÜÀíÆ÷Ïà¹ØµÄ±ðÃûÉèÖÃÖÐËùÃèÊöµÄÐÅÏ¢½øÐÐÁ¬½Ó
×îºó£¬Èç¹ûÔÚ±ðÃûÐÅÏ¢ÖÐûÓÐÌṩÏà¹ØµÄÉèÖÃÐÅÏ¢£¬Ôò»á¸ù¾Ý¿Í»§¶ËÉèÖõÄÐÒéµÄ˳Ðò£¬ÒÀ´Î³¢ÊÔÓë·þÎñÆ÷¶Ë½øÐÐÁ¬½Ó¡£
ÏÂÃæ½éÉÜÕâËÄÖÖ·½Ê½µÄÁ¬½ÓÃüÁ
ĬÈÏÇé¿öÏ£¬ÎÒÃÇÒ»°ãÓÃÈçÏÂÃüÁî½øÐÐÁ¬½Ó£º
sqlcmd -S HT-WINSERVER1 ----Á¬½ÓĬÈÏʵÀý
sqlcmd -S HT-WINServer1\mssql2k5 ----Á¬½Ó¸Ã·þÎñÆ÷ÉϵķÇĬÈÏʵÀý
sqlcmd -S 172.16.15.233
sqlcmd -S 172.16.15.233\mssql2k5
sqlcmd -S 172.16.15.233,1121 ----²ÉÓö˿ںŵÄÐÎÊƽøÐÐÁ¬½ÓÃüÃûʵÀý
sqlcmd -S 172.16.15.233,1433 ----²ÉÓö˿ںŵÄÐÎÊƽøÐÐĬÈÏʵÀý
sqlcmd -S HT-WINSERVER1,1121 ----²ÉÓö˿ںŵÄÐÎÊƽøÐÐÁ¬½ÓÌض¨µÄÃüÃûʵÀý
ͨ¹ýÖ¸¶¨ÐÒéµÄ·½Ê½½øÐÐÁ¬½Ó(ÏÂÃæÊäÈëIPµÄµØ·½¶¼¿ÉÒÔÓÉ·þÎñÆ÷Ãû´úÌæ)£º
sqlcmd -S tcp£º172.16.15.233\mssql2k5, 1121 ----²ÉÓÃtcp/ip·½Ê½Á¬½Ó
sqlcmd -S tcp:172.16.15.233,1121
sqlcmd -S np:\\172.16.15.233\pipe\sql\query
-----²ÉÓÃÃüÃû¹ÜµÀ·½Ê½Á¬½Ó
sqlcmd -S np:\\172.16.15.233\pipe\MSSQL$mssql2k5\sql\query
sqlcmd -S
lpc:\172.16.15.233\mssql2k5
-----²ÉÓù²ÏíÄڴ淽ʽÁ¬½Ó
sqlcmd -S via:<computer
name>,<port
num>,<NIC number>
----ʹÓÃVIA·½Ê½Á¬½Ó
ÔÚSQL ServerÁ¬½ÓµÄ¹ý³ÌÖУ¬ÓÐʱÎÒÃÇͨ²Å²ÉÓò»ÊäÈë¶Ë¿ÚºÅµÄ·½Ê½½øÐÐÁ¬½Ó£¬Õâʱ¾ÍÐèÒªÒ»¸ö·þÎñÊÇÆô¶¯µÄ£¬¼´SQL Server
Browser£º
ÔÀí£º
Æô¶¯Ò»¸ö SQL Server ʵÀýºó£¬Èç¹ûΪ
SQL Server ÆôÓÃÁË TCP/IP »ò VIA ÐÒ飬·þÎñÆ÷
Ïà¹ØÎĵµ£º
ALTER FUNCTION [dbo].[fun_tongji]()
RETURNS @t1 table (
yue int ,
money int
)
AS
begin
Declare @i int
set @i=1
-- declare @t1 table (
-- yue int ,
-- money int
-- )
while (@i<=12)&n ......
sql ´úÂë:
---------------------------------------------------------
/*
a ±íÃû
Èç¹ûÔÚsql ²éѯ·ÖÎöÆ÷µ±ÖгöÏÖ
" SQL Server ×èÖ¹Á˶Ô×é¼þ 'xp_cmdshell' µÄ ¹ý³Ì'sys.xp_cmdshell' µÄ·ÃÎÊ£¬ÒòΪ´Ë×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö¶ø±»¹Ø± ......
תÔØÒ»¸öBDBµÄÏà¹Ø½éÉÜ£¬»ù±¾¿ÉÒÔµ±ËÙ³ÉÊÖ²áÓ㬸ü¶àµÄÎĵµ¿ÉÒÔÈ¥Oracle¹Ù·½ÍøÕ¾ÏÂÔØ¡£
SQL ¿ª·¢ÈËÔ± Oracle Berkeley DB Ö¸ÄÏ
×÷ÕߣºMargo Seltzer
Oracle Berkeley DB Öг£Óà SQL º¯ÊýʹÓÃÖ¸ÄÏ¡£
2007 Äê 9 Ô·¢±í
³£³£ÓÐÈËÎÊ Oracle Berkeley DB “ÎÒÈçºÎÔÚ Berkeley DB ÖнøÐÐ <SQL ²éѯ>£¿"Òò´Ë£¬ÎÒÃÇ ......
ͨ³££¬ÄãÐèÒª»ñµÃµ±Ç°ÈÕÆںͼÆËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬ÄãµÄ³ÌÐò¿ÉÄÜÐèÒªÅжÏÒ»¸öÔµĵÚÒ»Ìì»òÕß×îºóÒ»Ìì¡£ÄãÃǴ󲿷ÖÈË´ó¸Å¶¼ÖªµÀÔõÑù°ÑÈÕÆÚ½øÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»ºó½ö½öÓ÷ָî³öÀ´µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ¼¸¸öº¯ÊýÖмÆËã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡ÔÚÕâƪÎÄÕÂÀÎÒ½«¸æËßÄãÈçºÎʹÓÃDATEADDºÍ DATEDIFFº¯ÊýÀ´¼ÆËã³öÔÚÄãµÄ³ÌÐò ......