vs.net Óë Sql server °²×°
ÔÚÏȰ²×°ÁËvs.net 2008 ºóÔõô°²×° Sql server 2005¡£ËÑÁ˺ܶàÎÄÕ£¬¿ÉÊÇ»¹ÊÇûÓп´µ½Ôõô²ÅÄܹ»°²×°ÉÏ¡£ ×ÜÊÇÔÚ°²×°sql serverµÄ¿Í»§¶Ë£¨management studio£©Ê±ºò±¨´í£¬×°ÄǸöÊý¾Ý¿â server ÒýÇæµÄʱºòûÓÐÎÊÌâ¡£°Ñ.net frameworkÐ¶ÔØÁËÒ»ºó£¬»¹ÊÇ×°²»ÉÏ¡£ºÃÏñ˵ÒѰ²×°µÄ°æ±¾±È´ý°²×°µÄ°æ±¾¸ß£¬Éý¼¶Ê§°Ü¡£¸ã²»Çå³þµ½µ×ÒªÐ¶ÔØ×°vsʱºò×°µÄÄÇЩ×é¼þ¡£ ÓÐûÓиßÊÖ¸ø¸ö¿ÉÒÔÓõķ½°¸°¡£¬ÐèÒªÏÈÐ¶ÔØÄÇЩ¸ö×é¼þ£¡£¡Ð»ÁË
×î¼Ñ·½·¨¾ÍÊÇÐ¶ÔØvs.net 2008 È»ºó°²×°Sql server 2005 ÔÚ°²×°vs.net 2008 ÒòΪÔÚvs.net 2008 ÀïÃæ¼¯³ÉÁËÐí¶àSql server ³ÌÐò ÊÖ¶¯Ð¶ÔØÂé·³ ÎÒµÄûÓгöÏÖ´ËÀàÎÊÌ⣡ ÖØ×öϵͳ¿´¿´ÒýÓÃ ÖØ×öϵͳ¿´¿´ ºÇºÇ ...ͦÎÞÓï End_rbody_60319948//--> ¸Ã»Ø¸´ÓÚ2009-10-11 08:53:15±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP cedar_zhao (cedar_zhao) µÈ¡¡¼¶£º #6Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-10-10 21:54:47 Çë²é¿´ÄãµÄϵͳºÍsqlserver2005°æ±¾ÊÇ·ñ¼æÈÝ£¬xpÖ»Äܰ²×°¿ª·¢°æ±¾µÄ»òÕ߸öÈ˰汾µÄ ²»Äܰ²×°ÆóÒµ°æµÄ server ¿ÉÒÔ°²×°ÆóÒµ°æµÄ °²×°³ÌÐòÏȰ²×°µÍ°æ±¾µÄ£¬ºó°²×°¸ß°æ±¾µÄ£»Èç¹ûÊÇÏàͬ°æ±¾µÄ£¬ÏÖ×°VS£¬ÔÙ°²×°SQL¡£ Èç¹û°²×°³öÏÖÁËÎÊÌ⣬ֻÐèÒª´Ó×¢²á±íÖÐÐ¶ÔØ¶ÔÓ¦µÄ³ÌÐòµ½HKEY_CURRENT_USERºó¾Í¿ÉÒÔÖØÐ°²×°ÁË£¬Ð¶ÔØVSÐèÒª´óÁ¿Ê±¼ä£¬SQL¿ÉÒÔÈÌÊÜ£»Èç¹ûÊÇÐ¶ÔØVS£¬²»ÈçÖØÐ°²×°——Ì«·Ñʱ¼äÁË£¬³ý·ÇÊÇΪÁËѧϰÈçºÎÐ¶ÔØ¡£ jiefen ×°Íêvs£¬×°vs sp1£¬ÔÙ×°sql
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ? dts¹¤¾ß µ¼Èëµ¼³ö¹¤¾ß. DD ¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»ÁËµÄ Ö±½ÓÐ ......
sql2005 select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
PBÖпª·¢µÄ¡£ DateTime startTime=DateTime(em_1.Text) DateTime endTime=DateTime(em_2.Text) string sql sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд £º ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8 ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£ ½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë ÇëÎÊÎÊÌâÔÚÄÄ£¿ ×°¸öÖÐÎÄÈí¼þ¼´¿É. ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......