SQLÖ®¾Å SQLµÄ°²×°Óë¹ÜÀí
SQL Server °²×°×¢ÒâÊÂÏ£¡
==============================
http://www.cnblogs.com/pvistely/archive/2008/12/31/1365702.html
1. ÐèÒª.Net Framework 3.5£¬ÈôÔÚVista»ò¸ü¸ßµÄOSÉÏÐèÒª3.5 SP1µÄÖ§³Ö£¨ÔÚSQL2008°²×°µÄÇ°»á×Ô¶¯¸üа²×°£©
2. ÐèÒªWidnows PowerShellµÄÖ§³Ö,WPSÊÇÒ»¸ö¹¦Äܷdz£Ç¿´óµÄShellÓ¦Óã¬ÃüÁîÓëDOX/UNIX¼æÈݲ¢Ö§³ÖÖ±½Óµ÷ÓÃ.NETÄ£¿é×öÐÐÃüÁî±à¼£¬ÊǷdz£ÖµµÃÉîÈëÑо¿µÄ¹¤¾ß£¨ÔÚSQL2008°²×°Ê±»á×Ô¶¯¸üа²×°£©
3. ÐèҪȷ±£Windows InstallerµÄ³É¹¦Æô¶¯£¬ÐèÒª4.5ÒÔÉÏ°æ±¾£¨ÐèÒª¼ì²é·þÎñÆô¶¯×´Ì¬service.msc)
4. ÐèÒªMDAC2.8 sp1µÄÖ§³Ö£¨XPÒÔÉÏϵͳÖÐÒѼ¯³É£©
5. Èô»úÆ÷ÉÏÒѾ°²×°Visual studio 2008ÔòÐèÒªVS 2008 sp1ÒÔÉÏ°æ±¾µÄÖ§³Ö
±È½ÏÁ½¸öÊý¾Ý¿â±í½á¹¹µÄ²îÒì
========================
http://www.itwis.com/html/database/sqlserver/20090902/5907.html
ͼ½â¾Û´ØË÷ÒýÓë·Ç¾Û´ØË÷ÒýµÄÇø±ð¼°ÆäÓÅ»¯²éѯ
==============================
http://www.itwis.com/html/database/sqlserver/20090611/4602.html
named pipes
==============================================
"ÃüÃû¹ÜµÀ"»ò"ÃüÃû¹ÜÏß"(Named Pipes)ÊÇÒ»ÖÖ¼òµ¥µÄ½ø³Ì¼äͨÐÅ(I P C)»úÖÆ,
Microsoft Windows NT,Windows 2000,Windows 95ÒÔ¼°Windows 98¾ùÌṩÁ˶ÔËüµÄÖ§³Ö
(µ«²»°üÀ¨Windows CE).ÃüÃû¹ÜµÀ¿ÉÔÚͬһ̨¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,»òÔÚ¿çÔ½Ò»¸öÍøÂçµÄ
²»Í¬¼ÆËã»úµÄ²»Í¬½ø³ÌÖ®¼ä,Ö§³Ö¿É¿¿µÄ,µ¥Ïò»òË«ÏòµÄÊý¾ÝͨÐÅ.
ÃüÃû¹ÜµÀÓë TCP/IP Ì×½Ó×Ö
ÔÚ¿ìËÙ¾ÖÓòÍø (LAN) »·¾³ÖУ¬´«Êä¿ØÖÆÐÒé»ò Internet ÐÒé (TCP/IP) Ì×½Ó×Ö¿Í»§¶ËºÍÃüÃû¹ÜµÀ¿Í»§¶ËÔÚÐÔÄÜ·½Ãæ²»ÏàÉÏÏ¡£µ«ÊÇ£¬ÍøÂçËÙ¶ÈÔ½Âý£¨ÈçÔÚ¹ãÓòÍø (WAN) »ò²¦ºÅÍøÂçÉÏ£©£¬TCP/IP Ì×½Ó×Ö¿Í»§¶ËÓëÃüÃû¹ÜµÀ¿Í»§¶ËµÄÐÔÄܲîÒìÔ½Ã÷ÏÔ¡£ÕâÊÇÒòΪ½ø³Ì¼äͨѶ (IPC) »úÖÆÔÚ¶ÔµÈÏî¼äµÄͨѶ·½·¨²»Í¬¡£
¶ÔÓÚÃüÃû¹ÜµÀ£¬Í¨³£ÍøÂçͨÐŽ»»¥ÐÔ¸üÇ¿¡£Ò»¸ö¶ÔµÈÏîÖ±µ½ÁíÒ»¸ö¶ÔµÈÏîʹÓöÁÈ¡ÃüÁîÇëÇóÊý¾Ýʱ²Å·¢ËÍÊý¾Ý¡£ÔÚ¿ªÊ¼¶ÁÈ¡Êý¾ÝÇ°£¬ÍøÂç¶ÁÈ¡Ò»°ã°üÀ¨Ò»ÏµÁпúÊÓÃüÃû¹ÜµÀµÄÐÅÏ¢¡£ÕâÔÚÂýËÙÍøÂçÖпÉÄÜ»¨·Ñ·Ç³£¶à²¢µ¼Ö¹ý¶àµÄÍøÂçÁ÷Á¿£¬ÆäËüµÄÍøÂç¿Í»§¶Ë·´¹ýÀ´Ò²»áÊܵ½Ó°Ïì¡£
²ûÃ÷ËùÌÖÂÛµÄÊDZ¾µØ¹ÜµÀ»¹ÊÇÍøÂç¹ÜµÀÒ²ºÜÖØÒª¡£Èç¹û·þÎñÆ÷Ó
Ïà¹ØÎĵµ£º
½ñÌ죬Óöµ½ÁËÕâÑùµÄÒ»¸öÀý×Ó£º
SQL ServerË÷Òýͳ¼ÆÐÅϢδ¼°Ê±¸üУ¬µ¼ÖÂÅÅÐò»ìÂÒ
ÎÒÃÇÖªµÀ£¬ÔÚsql
serverÉÏ´´½¨Ë÷Òýºó£¬Í¬Ê±»á¶Ô¸ÃË÷ÒýÉϵÄÖµ½øÐÐÅÅÐò£¬µ«¶ÔÓÚÐÂÔö¼ÓµÄÖµ£¬Èç¹ûδÄܼ°Ê±¸üÐÂͳ¼ÆÐÅÏ¢£¬½«ÓпÉÄܵ¼ÖÂÅÅÐòµÄ»ìÂÒ£¬Ò²¾ÍÊÇûÓÐÅÅÐò¡£
ÕâÊDzúÉúÎÊÌâµÄÓï¾ä£º
Select * from V_L_IcStockProInEntry Where FInt ......
sql ·þÎñÆ÷½ÇÉ« Êý¾Ý¿â½ÇÉ«
·þÎñÆ÷½ÇÉ«
ËùÓеķþÎñÆ÷½ÇÉ«¶¼ÊÇ“¹Ì¶¨µÄ”½ÇÉ«£¬²¢ÇÒ£¬´ÓÒ»¿ªÊ¼¾Í´æÔÚÓÚÄÇÀï——×Ô°²×°ÍêSQL ServerµÄÄÇÒ»¿ÌÆð£¬Ä㽫ӵÓеÄËùÓзþÎñÆ÷½ÇÉ«¾ÍÒѾ´æÔÚÁË¡£
½Ç¡¡¡¡É«
ÌØ¡¡¡¡ÐÔ
sysadmin
¸Ã½ÇÉ«Äܹ»Ö´ÐÐSQL ServerÉϵÄÈκβÙ× ......
º¯ÊýÈçÏÂ
CREATE FUNCTION StockBalance_AmountIn(@SortID int)
RETURNS numeric(18,4)
AS
BEGIN
Declare @dblReturn numeric(18,4)
Select @dblReturn = SUM(AmountCurrentMonthIn) from AT_Materiel_StockBalance Where SortID = @SortID
Return (@dblReturn)
END
......
ÔÚSQL SERVER 2005ÖбØÐëÓÃרÓùÜÀíÁ¬½Ó²Å¿ÉÒԲ鿴¹ý³Ì¹ý³ÌÖÐÓõ½µÄ±í
EG£ºsqlcmd -A
1>use test
2>go
1>sp_decrypt 'p_testa'
2>go
Text
----------------------
Create procedure P_testa
with encryption
as
select * from test
create PROCEDURE [dbo].[sp_decrypt]
(@procedure s ......