.net+sqlÊÔÓÿռ䣿£¿
ÎÒÍøÉÏÉêÇëÁËÒ»¸öÄÜÊÔÓÃsqlµÄÍøÖ·£¬°ÑÊý¾Ý¿â±¸·Ý³É1.bak£¬È»ºóÉÏ´«µ½ËûµÄ¿Õ¼ä¸²¸Ç£¬¾ÍÐУ¬È»ºó¸ÄÁËÏÂ.netµÄÁ¬½ÓµØÖ· µ«×ÜÊDz»Äܳɹ¦Á¬½Ó¡£
ºóÀ´ÎÒÄǸöÉêÇë¿Õ¼äµÄ±»¹ØÁË£¬ÏÖÔÚÓÐÔÝÍ£¿Õ¼äµÄÉêÇë
ËùÒÔÇëÎÊÏ ËÓÐÖ§³ÖsqlÊÔÓÿռäµÄÍøÕ¾Âð£¿
ÊÔÓÃ2ÌìÒ²ÐУ¬Ö»ÒªÄÜÈÃÎÒÁ¬½Ó³É¹¦¾ÍÐУ¬ÎÒ×òÌìÕÒÁ˺þ㬶¼Ã»ÕÒµ½£¬ËùÒÔÏ£Íû¸÷λÄܰïæÌṩһÏÂsqlÃâ·ÑÊÔÓõĿռ䣬лл¡£
²âÊԵϰÔÚ×Ô¼ºµÄ»úÆ÷ÉϾͿÉÒÔÁË£¬ÎªÊ²Ã´·ÇÒªÕҿռ䣿
»Ø´ð1Â¥µÄ ÔÚ×Ô¼º»úÆ÷ÉϲâÊÔ Äܹ»Õý³£´ò¿ª µ«´«µ½¿Õ¼äºó ¾Í²»ÄÜÕý³£´ò¿ªÁË ËùÒÔ²ÅÒª´«µ½¿Õ¼äÉÌÈ¥²âÊÔ
»Ø´ð1Â¥µÄ ÎÒ¾õµÃ×Ô¼ºÃ»°Ñsql¿Õ¼äµÄsqlÊý¾Ý¿â´¦ÀíºÃ ËùÒÔ²ÅÐèҪȥ¿Õ¼ä²âÊ﵀ µ«Äǿռ䱻¹ØÁË ²»ÄÜÉêÇëÁË ËùÒÔ²ÅÎÊÄܲ»ÄÜÌṩһ¸öÊÔÓõÄsql¿Õ¼ä
·þÎñÆ÷²»¹ýÒ²ÊÇ̨µçÄÔ ºÍÄã±¾µØ²âÊÔÇé¿ö»ù±¾Ò»Ö£¡
http://www.yes987.com/ÄãÊÔÊÔÕâ¸ö¿ÉÒÔÂð£¿ÒÔǰÎÒÓõÄÄǸöÍøÖ·ÍüÁË£¬ÔÝʱÕÒÁ˸ö£¬ÄãÊÔÏÂ
¿ÉÒÔÈ¥¾ÅÍø»¥Áª
www.9host.cn
ËûÃǵĿռä¿ÉÒÔÊÔÓÃÈýÌì
¿´²»¶®¡£
ÄÇÖÖÃâ·Ñ¿Õ¼äµÄ²»ÄÜʹÓÃSQLSeverµÄºÃ¶à¹¦Äܰɣ¬PÈç´æ´¢¹ý³Ì
www.pow.com.cn
¿ÉÒÔÃâ·ÑÊÔÓÃÈýÌì..Äã¶Ô¿Í·þ˵һÏÂÒ²¿ÉÒÔÊÔÓÃÎåÌìµÄ...Ҫע²á
Ïà¹ØÎÊ´ð£º
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´
ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)
SQL ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......