ÔÚ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Óï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ³£»áÓõ½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*/
±íÃ÷¶ÔÓï¾ä¿ ......
Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩËûÏëµÃÖªµÄÊý¾Ý£¬Õâ¾ÍÊÇËùνµÄSQL Inj ......
SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó:
Ò»."SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø"
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔÒò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµ ......
SQL Enlight 1.5 ÆÆ½â µÚ¶þ°æ ÊÕ²Ø
ÆÆ½âÉùÃ÷£ºÎÒµÄÆÆ½â½öÓÃÓÚÑо¿£¬ÇëÎðÓÃÓÚÉÌÒµÓÃ;£¬ÐèҪʹÓÃÇ빺ÂòÕý°æÈí¼þ¡£
¿É¶ñµÄUbitSoft£¬ÎÒµÄÆÆ½â³öÀ´»¹Ã»¼¸Ì죬ËûµÄ³ÌÐò¾Í¸Ä±äÁËÑéÖ¤Âß¼£¬ËäÈ»ÎÒ¾õµÃSQL EnlightµÄ¹¦Äܲ»ÊǷdz£Ç¿´ó£¬µ«ÊÇËûµÄ·ÀÆÆ½â¹¦Äܵ¹ÊÇÏÂÁ˲»ÉÙ¹¦·ò£¬³ýÁ˺ËÐÄ´úÂëÓÃvc++.net±àдµÄnative cod ......
SELECT
(case when a.colorder=1 then d.name else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity ......