PL/SQLÈçºÎÉèÖÃÊôÐÔ£¬Ê¹ÆäÄÜ×Ô¶¯Ê¶±ð±íÃû
±ÈÈç˵£¬µ±ÎÒÔÚSQL±à¼ÇøÊäÈëYS_£¬ÄÇôPL/SQL×Ô¶¯½«Êý¾Ý¿âÖпɱ»·ÃÎÊÇÒ±íÃûÒÔYS_¿ªÊ¼µÄ±íÈ«²¿ÏÔʾ³öÀ´
ûÉèÖÃ,¾ÍÄÜ´ïµ½ÄãÕâÑùµÄЧ¹û.¹À¼ÆÄ¬ÈÏÉèÖþÍÊÇÕâÑùµÄ
ĬÈÏÉèÖþÍÊÇÕâÑùµÄ£¬»á×Ô¶¯µ¯³öÒ»ÁбíÃ÷×ÖÈÃÄãÑ¡ÔñµÄ¡£
ĬÈÏÉèÖþͿÉÒÔ´ïµ½ÄãµÄÒªÇó°Ñ
ÊÇÕâÑùµÄ
F6
SQL code:
ĬÈϾÍÊÇÕâÑùµÄЧ¹û¡£
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN
¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª
ÐÕÃû ¿ÆÄ¿ ³É¼¨
ÕÅÈý Ó¢Óï 90
ÀîËÄ Ó¢Óï&nb ......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......