ͼÎÄÏê½âSilverlight·ÃÎÊMSSQLÊý¾Ý¿â
ÔÚÒø¹âÖйúÍø£¨SilverlightChina.Net£©ÓÐһƪ"SilverlightÓë³£ÓÃÊý¾Ý¿â»¥²Ù×÷ϵÁÐ"ÎÄÕ£¬ÆäÖнéÉÜÁËʹÓÃSilverlight´æÈ¡²»Í¬Êý¾Ý¿âµÄ·½·¨ºÍ²½Öè¡£µ«ÊǶÔÓÚSilverlight´æÈ¡MS SQL½éÉܵIJ»¹»È«Ã棬ÕâÀïÎÒÏë½éÉÜSilverlightÈçºÎͨ¹ýWCF·ÃÎÊMSSQLÊý¾Ý¿â´æ´¢¹ý³ÌµÄ¡£Ï£Íû¶Ô´ó¼ÒÄܹ»ÓÐËù°ïÖú¡£
ÎÒÃÇҪʵÏÖ£¬ Óû§ÊäÈëÓû§ÃûºÍÃÜÂëºó£¬µã»÷µÇ¼°´Å¥£¬´«µÝÓû§ÃûºÍÃÜÂëµ½·þÎñÆ÷¶Ë, ͨ¹ýWCF·ÃÎÊMSSQLÊý¾Ý¿â£¬µ÷Óô洢¹ý³Ì£¬ÔÚ·þÎñÆ÷¶Ë¶ÔÓû§ÃûºÍÃÜÂë½øÐÐÆ¥Å䣬ƥÅä³É¹¦£¬Ôò·µ»ØµÇ¼³É¹¦£¬·ñÔò£¬ÔòÊÇʧ°Ü¡£
ÔÚÎÄÕ¿ªÊ¼Ç°£¬ÎÒÃÇÐèÒª×öÒ»ÏÂ×¼±¸¹¤×÷£¬
¿ª·¢»·¾³ÐèÇó£º VS2008 SP1£¬ Silverlight 3 Develop Tools for VS2008 SP1£¬ ¿Í»§¶ËSilverlight 3 Runtime£¬ MSSQL 2005 SP3 £»
½¨Á¢Àý³ÌÊý¾Ý¿â SilverlightDemo£¬ÔÚÊý¾Ý¿âÖн¨Á¢Ò»¸öбí Users£¬°üº¬ÒÔÏÂ×ֶΣ»
Ìí¼ÓÄÚÈݵ½Users±í£¬ÎªÁË·½±ãÆð¼û£¬ÃÜÂëÈ«²¿Ê¹ÓÃÃ÷ÎÄ£¬ÔÚÕýʽÏîÄ¿ÖУ¬½¨Òé¶ÔÃÜÂë×ֶνøÐмÓÃÜʹÓá£
ÕâÀÎÒÃÇÑéÖ¤Óû§ÃûºÍÃÜÂ룬ÓÐÁ½ÖÖ¼òµ¥·½Ê½£¬
Ò»ÊÇʹÓô洢¹ý³Ì¶ÁÈ¡Óû§ÃûºÍÃÜÂ룬ȻºóÔÚ·þÎñÆ÷¶Ë½øÐÐÓû§ÃûºÍÃÜÂëÆ¥ÅäУÑ飬Èç¹û²éÕÒµ½Æ¥ÅäÊý¾Ý£¬Ôò·µ»ØµÇ¼³É¹¦£¬·ñÔò£¬ÔòÊǵǼʧ°Ü£»
¶þÊÇ´«Óû§ÃûºÍÃÜÂëµ½´æ´¢¹ý³ÌÖУ¬ÔÚÊý¾Ý¿â´æ´¢¹ý³ÌÖнøÐÐÅжϣ¬Ê¹ÓÃSelectÓï¾ä½øÐвéÕÒ£¬¶ÔÓ¦Óû§ÃûºÍÃÜÂ룬Èç¹û²éÕÒµ½Æ¥Åä½á¹û£¬Ôò·µ»ØÓû§ID£¬ ·þÎñÆ÷¶Ë½ÓÊÕµ½Óû§ID£¬Ôò·µ»ØµÇ¼³É¹¦£¬·ñÔò£¬ÔòÊÇʧ°Ü£»
ÔÚ±¾ÀýÖУ¬Ö÷ÒªÊǶÔSilverlight·ÃÎÊÊý¾Ý¿â½øÐн²Êö£¬ËùÒÔ£¬¶ÔÓÚÑéÖ¤·½·¨£¬²»½øÐÐÏêϸÃèÊöºÍ½²½â£¬Èç¹ûÓÐÎÊÌ⣬¿ÉÒÔÁôÑÔ¸øÎÒ£¬ÎÒÃǼÌÐøÌÖÂÛ£¬ÕâÀÎÒ½«Ê¹ÓõÚÒ»ÖÖÑéÖ¤·½·¨¡£ Ϊ´Ë£¬½¨Á¢Ò»¸ö¼òµ¥µÄ´æ´¢¹ý³Ì£º
1 CREATE PROCEDURE [dbo].[Login]
2 ( @UserName Varchar(30))
3 AS
4
5 Select cUserName, cPassword
6 from Users
7 Where cUserName = @UserName
8
9 RETURN
10
11 SET NOCOUNT ON
ÔÚÍê³ÉÉÏÃæµÄ×¼±¸¹¤×÷ºó£¬¿ªÊ¼½¨Á¢ÐµÄSilverlightÏîÄ¿£¬
1. ½¨Á¢Ò»¸öÐÂÏîÄ¿"Silverli
Ïà¹ØÎĵµ£º
create proc [dbo].[sp_lockinfo]
@kill_lock_spid bit=0, --ÊÇ·ñɱµô×èÈûµÄ½ø³Ì,1 ɱµô, 0 ½öÏÔʾ
@show_spid_if_nolock & ......
MemcacheºÍMsSQL½»»¥Á÷³Ìͼ
ÈçÉÏͼ£¬´«Í³µÄ²éѯ·½·¨ÊÇÖ±½Ó²éѯÊý¾Ý¿â£¬Êý¾Ý¿â½«½á¹û·µ»Ø¸ø²éѯÓï¾ä£¬¶øµ±ÓÐMemcacheÖм仺´æ²ãʱ£¬²éѯµÄÊÇMemcache»º´æÊý¾Ý£¬ÏÂÃæÏêϸÁ˽âMemcache¸÷ÀàÊý¾Ý²Ù×÷ÔÀí£º
1£¬²éѯÊý¾Ý(select)£¬Ê×ÏÈͨ¹ýÖ¸¶¨µÄKey²éѯ(get)MemcacheÖм仺´æ²ãÊý¾Ý£¬Èç¹û´æÔÚÏà¶ÔÓ¦Êý¾Ý£¬ÔòÖ±½Ó»ñÈ¡³öÊý¾Ý½ ......
ORACLE
CREATE OR REPLACE FUNCTION SETSTATE(OLDVALUE VARCHAR2, POS NUMBER, SVALUE VARCHAR2)
RETURN VARCHAR2
IS
RETURN_VALUE VARCHAR2 (20);
LEN NUMBER(8);
I NUMBER(8);
TEMP_VALUE VARCHAR2(1);
BEGIN
LEN := LENGTH(OLDVALUE);
IF POS > ......
תÔØ http://www.jb51.net/article/17875.htm
MS-SQLÓαêµÄʹÓü°Àí½â windows»òDOSµÄ“¹â±ê”²»Í¬£¬MS-SQLµÄÓαêÊÇÒ»ÖÖÁÙʱµÄÊý¾Ý¿â¶ÔÏ󣬼ȶԿÉÓÃÀ´Ðýת´¢´æÔÚϵͳÓÀ¾Ã±íÖеÄÊý¾ÝÐеĸ±±¾£¬Ò²¿ÉÒÔÖ¸Ïò´¢´æÔÚϵͳÓÀ¾Ã±íÖеÄÊý¾ÝÐÐ
ÓαêΪÄúÌṩÁËÔÚÖðÐеĻù´¡É϶ø²»ÊÇÒ» ......
Õâ¶Îʱ¼ä¿´Á˹ØÓÚÔÚSQL server ÖÐͨ¹ýÈÕÖ¾ºÍʱ¼äµãÀ´»Ö¸´Êý¾Ý¡£Ò²¿´ÁËһЩÍøÉϵÄÀý×Ó£¬¿´ÈçºÎͨ¹ýÈÕÖ¾À´»Ö¸´Êý¾Ý¡£
Ç°ÌáÌõ¼þ£º
Êý¾Ý¿âµÄ¹ÊÕϻָ´¸ÄΪ·Ç¼òµ¥Ä£Ê½£¬È¥µô×Ô¶¯¹Ø±ÕºÍ×Ô¶¯ÊÕËõÁ½¸öÑ¡Ïî
&nbs ......