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

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 ЭÒ飬·þÎñÆ÷


Ïà¹ØÎĵµ£º

sql ²éѯ³öÀ´Ò»¸ö±íÔÚ²åÈëµ½ÁíÒ»¸ö±íÀï

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 °Ñ±íµ¼³É.TXTÎļþ

sql ´úÂë:
---------------------------------------------------------
/*
  a        ±íÃû
  Èç¹ûÔÚsql ²éѯ·ÖÎöÆ÷µ±ÖгöÏÖ
  " SQL Server ×èÖ¹Á˶Ô×é¼þ 'xp_cmdshell' µÄ ¹ý³Ì'sys.xp_cmdshell' µÄ·ÃÎÊ£¬ÒòΪ´Ë×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö¶ø±»¹Ø± ......

SQL ¿ª·¢ÈËÔ± Oracle Berkeley DB Ö¸ÄÏ£¨zz£©

תÔØÒ»¸öBDBµÄÏà¹Ø½éÉÜ£¬»ù±¾¿ÉÒÔµ±ËÙ³ÉÊÖ²áÓ㬸ü¶àµÄÎĵµ¿ÉÒÔÈ¥Oracle¹Ù·½ÍøÕ¾ÏÂÔØ¡£
SQL ¿ª·¢ÈËÔ± Oracle Berkeley DB Ö¸ÄÏ
×÷ÕߣºMargo Seltzer
Oracle Berkeley DB Öг£Óà SQL º¯ÊýʹÓÃÖ¸ÄÏ¡£
2007 Äê 9 Ô·¢±í
³£³£ÓÐÈËÎÊ Oracle Berkeley DB “ÎÒÈçºÎÔÚ Berkeley DB ÖнøÐÐ <SQL ²éѯ>£¿"Òò´Ë£¬ÎÒÃÇ ......

MS SQL ServerÈÕÆÚ¼ÆËã

ͨ³££¬ÄãÐèÒª»ñµÃµ±Ç°ÈÕÆںͼÆËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬ÄãµÄ³ÌÐò¿ÉÄÜÐèÒªÅжÏÒ»¸öÔµĵÚÒ»Ìì»òÕß×îºóÒ»Ìì¡£ÄãÃǴ󲿷ÖÈË´ó¸Å¶¼ÖªµÀÔõÑù°ÑÈÕÆÚ½øÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»ºó½ö½öÓ÷ָî³öÀ´µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ¼¸¸öº¯ÊýÖмÆËã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡ÔÚÕâƪÎÄÕÂÀÎÒ½«¸æËßÄãÈçºÎʹÓÃDATEADDºÍ DATEDIFFº¯ÊýÀ´¼ÆËã³öÔÚÄãµÄ³ÌÐò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ