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

ÔÚSQL SERVER 2005Öе÷ÓÃWeb Service

¡¾IT168 ¼¼ÊõÎĵµ¡¿
½éÉÜ
    SQL SERVER2005ÌṩÁËÔÚ.NETÖÐ×Ô¶¨Ò庯Êý¡¢´æ´¢¹ý³Ì¡¢¾ÛºÏ¡¢´¥·¢Æ÷ÒÔ¼°ÀàÐ͵ŦÄÜ¡£ÓÚÊÇ£¬ÎÒÃÇ¿ÉÒÔÔÚÊý¾Ý¿âµÄº¯Êý¡¢´æ´¢¹ý³Ì»òÀàÐÍÕûºÏ.NET¶ÔÏó·½·¨µÈ¡£ÔÚ֮ǰµÄһƪÎÄÕ£¬ÎÒÃÇÑÝʾÁËÈçºÎ½«ÕýÔò±í´ïʽ¹¦ÄÜÕûºÏµ½SQL CLRÖС£ÔÚ±¾ÎÄÖУ¬»¹ÊÇÑÝʾÕâÖÖÕûºÏ£¬µ«ÊÇÕâ´ÎÊÇ´ÓSQL CLRÖе÷ÓÃÒ»¸öWeb Service¡£ÎÒÃǽ«Ê¹ÓÃAdventureWorksÕâ¸öÑùÀýÊý¾Ý¿â£¬¶¨ÒåÒ»¸öº¯Êý£¬¸ù¾Ýhttp://www.webservicex.net/CurrencyConvertor.asmxÕâ¸öWeb ServiceÌṩµÄ»ãÂÊ£¬½øÐдÓÅ·Ôªµ½ÃÀÔªµÄÍâ»ãת»»¡££¨Õâ¸öWebServiceÌṩµÄ»ãÂÊ£¬Ö»ÓÃÓÚÑÝʾ£¬²»ÄÜ×÷ÎªÕæÊµ½ðÈÚ½»Ò×µÄÊý¾Ý¡££©
±¾ÎÄûÓÐÏêϸµÄÃèÊöËùÓеÄϸ½Ú£¬¶ÁÕßÓ¦¸Ã¾ßÓÐÒ»¶¨µÄÔÚSQL SERVER2005Ï¿ª·¢CLRµÄ»ù´¡¡£
¶¨Òåת»»º¯Êý
      Ê×ÏÈ£¬ÔÚVisual Studio 2005ÖУ¬¸ù¾Ý¿ª·¢Ä£°å£¬Ñ¡Ôñн¨Ò»¸öC#»òÕßVB.NETµÄSQL SERVERÏîÄ¿¡££¨×¢Ò⣺ÔÚBeta°æÖУ¬±ØÐëÔÚ°²×°VS2005֮ǰ°²×°SQL SERVER 2005£©
      *ÔÚһЩ·ÇÕýʽµÄVS2005µÄ°æ±¾ÖУ¬Ö±½ÓʹÓù¤¾ßÒýÓÃWebServiceÉú³ÉµÄ´úÀíÀ಻ÄÜÔÚSQL SERVER CLRÖÐʹÓá£Ô­ÒòÊÇÕâÖÖ´úÀíÀàÉú³ÉÁ˲»ÄÜʹÓÃÔÚCLRÖеÄͬ²½·½·¨¡£¾ßÌå¿É²Î¿¼Vineet Rao ÔÚ blogs.msdn.comÖеÄÎÄÕ¡£½â¾öµÄ·½·¨ÊÇÀûÓÃC:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BinĿ¼ÏµÄWSDL.exe¹¤¾ßÉú³ÉÀÏʽÒì²½·½·¨µÄ´úÀíÀֻ࣬ÓÃÕâÖÖÀà²ÅÄÜÔÚCLRÖÐÒÔExternal ACCESSµÄȨÏÞ¼ÓÔØ¡£Èç¹ûÎÒÃÇʹÓÓДµÄ´úÀíÀ࣬±ØÐëʹÓÃUnsafeµÄ°²È«¼¶±ð£¬ÕâÖÖ·½Ê½Ó¦¾¡Á¿±ÜÃâ¡£ÎÒÃÇ¿ÉÒÔʹÓÃÒ»¸öXMLÅäÖÃÎļþÀ´Éú³ÉÐèÒª¹æ·¶µÄ´úÀíÀà¡£´´½¨Ò»¸öÒÔÏÂÄÚÈݵÄXMLÎļþ£º
<wsdlParameters xmlns='http://microsoft.com/webReference/'>
<language>c#</language>
<protocol>Soap</protocol>
<nologo>true</nologo>
<sharetypes>false</sharetypes>
<webReferenceOptions>
<codeGenerationOptions>properties oldAsync</codeGenerationOptions>
</webReferenceOptions>
</wsdlParameters>
    ¼ÙÉè±£´æÂ·¾¶Îª£ºc:\oldwsdlconfig.xml£¨Èç¹ûʹÓÃVB.netÏîÄ¿£¬ÔòÌæ»»Ê¹ÓÃ<language>vb</language>ÔªËØ£©¡£È»ºó£¬Ê¹ÓÃÒÔÏÂÃüÁîÐÐÉú³É´úÀíÀࣺ
C:\Program Files\Microsoft Visual Studio 8\SDK\


Ïà¹ØÎĵµ£º

SQLÓï¾äÓÅ»¯·½·¨30Àý

ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle
HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT'; 2. /*+FIRST_ROWS*/
±íÃ÷¶ÔÓï¾ä¿ ......

SQL×¢ÈëÒ»ÈÕͨ£¨ÉÏ£©|Findnet.com.cn

Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾­ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩËûÏëµÃÖªµÄÊý¾Ý£¬Õâ¾ÍÊÇËùνµÄSQL Inj ......

SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó

SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó:
Ò»."SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø"
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔ­Òò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑ­ÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµ ......

SQL Enlight 1.5 ÆÆ½â µÚ¶þ°æ

SQL Enlight 1.5 ÆÆ½â µÚ¶þ°æ ÊÕ²Ø
  ÆÆ½âÉùÃ÷£ºÎÒµÄÆÆ½â½öÓÃÓÚÑо¿£¬ÇëÎðÓÃÓÚÉÌÒµÓÃ;£¬ÐèҪʹÓÃÇ빺ÂòÕý°æÈí¼þ¡£
¿É¶ñµÄUbitSoft£¬ÎÒµÄÆÆ½â³öÀ´»¹Ã»¼¸Ì죬ËûµÄ³ÌÐò¾Í¸Ä±äÁËÑéÖ¤Âß¼­£¬ËäÈ»ÎÒ¾õµÃSQL EnlightµÄ¹¦Äܲ»ÊǷdz£Ç¿´ó£¬µ«ÊÇËûµÄ·ÀÆÆ½â¹¦Äܵ¹ÊÇÏÂÁ˲»ÉÙ¹¦·ò£¬³ýÁ˺ËÐÄ´úÂëÓÃvc++.net±àдµÄnative cod ......

SQLÓï¾ä£º²éѯÊý¾Ý¿âÖÐËùÓзÇϵͳ±íµÄÐÅÏ¢

SELECT
       (case when a.colorder=1 then d.name else '' end)±íÃû,
       a.colorder ×Ö¶ÎÐòºÅ,
       a.name ×Ö¶ÎÃû,
       (case when COLUMNPROPERTY( a.id,a.name,'IsIdentity ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ