Æ´½ÓSQLÔì³ÉµÄÒâÏë²»µ½µÄºó¹û
Ö´ÐÐÊý¾Ý²Ù×÷ʱ£¬ÓÉÓÚÆ´½ÓSQL´æÔÚÖÖÖÖ±×¶Ë£¬Ôç¾ÍÓ¦¸ÃÅׯúÁË£¬µ«ÔÚÏÖʵ¿ª·¢Ê±£¬ÓÖÓÉÓÚÖÖÖÖÔÒò£¬¹«Ë¾Ò»Ö±²ÉÓÃÕâÖÖ·½Ê½£¨UI²ãºÍÂß¼²ã¶¼ÓÐÑϸñµÄ¹ýÂË£¬µ¹Ò²Ã»³öÏÖ¹ýʲôÎÊÌ⣩£¬µ«×òÌ쿪·¢Ê±È´³öÏÖÁËÒâÏë²»µ½µÄÎÊÌ⣬һ¸ö¼òµ¥µÄÓï¾ä»áÔì³ÉÑÏÖØºó¹û¡£¼òµ¥µÄÓï¾äʾÀýÈçÏ£º
/// <summary>
/// ¸üÐÂÖ÷¼üΪ2µÄ¼Ç¼µÄ×ÜÇ®Êý
/// </summary>
/// <param name="totalMoney">Ð޸ĺóµÄ×ÜÇ®Êý</param>
public void UpdateTotalMoney(int totalMoney)
{
int id = 2; //Êý¾Ý¿â±íÖ÷¼ü
int oldTotalMoney = 5000; //Ö÷¼üΪ2µÄ¼Ç¼ÔÀ´µÄ×ÜÇ®Êý
int newTotalMoney = totalMoney; //Ö÷¼üΪ2µÄ¼Ç¼¸ü¸ÄºóµÄÇ®Êý
int totalMoneyChange = oldTotalMoney - newTotalMoney; //×ÜÇ®ÊýµÄ±ä»¯Á¿
string sql = string.Format("update Test1220 set totalMoney = {0},remainMoney = remainMoney-{1} where id = {2}", newTotalMoney, totalMoneyChange, id); //×ÜÇ®Êý±ä»¯£¬Ê£Óà¿ÉÖ§ÅäÇ®ÊýÒ²¸ú×űàºÅ
SqlConnection con = new SqlConnection(sqlConnectString);
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
}
CREATE TABLE Test1220(
id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
totalMoney int NULL,
remainMoney int NULL
&n
Ïà¹ØÎĵµ£º
´´½¨×éºÏ²éѯ
¿ÉÓÃUNION²Ù×÷·ûÀ´×éºÏÊýÌõSQL²éѯ¡£ÀûÓÃUNION£¬¿É¸ø³ö¶àÌõSELECTÓï¾ä£¬½«ËüÃǵĽá¹û×éºÏ³Éµ¥¸ö½á¹û¼¯¡£
16.2.1 ʹÓÃUNION
UNIONµÄʹÓúܼòµ¥¡£ËùÐè×öµÄÖ»ÊǸø³öÿÌõSELECTÓï¾ä£¬ÔÚ¸÷ÌõÓï¾äÖ®¼ä·ÅÉϹؼü×ÖUNION¡£
¾ÙÒ»¸öÀý×Ó£¬¼ÙÈçÐèÒª¼Û¸ñСÓÚµÈÓÚ5µÄËùÓÐÎïÆ·µÄÒ»¸öÁÐ±í£¬¶øÇÒ»¹Ïë°üÀ¨¹©Ó¦ÉÌ1001ºÍ1002É ......
oracle³£ÓþµäSQL²éѯ
³£ÓÃSQL²éѯ£º
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
from dba_tablespaces t, dba_data_files d
where t.tablespace_name = d.tablespace_name
group by t.tablespace_name;
2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ ......
SQLÀïµÄEXISTSÓëin¡¢not existsÓënot in
ϵͳҪÇó½øÐÐSQLÓÅ»¯£¬¶ÔЧÂʱȽϵ͵ÄSQL½øÐÐÓÅ»¯£¬Ê¹ÆäÔËÐÐЧÂʸü¸ß£¬ÆäÖÐÒªÇó¶ÔSQLÖеIJ¿·Öin/not inÐÞ¸ÄΪexists/not exists
Ð޸ķ½·¨ÈçÏ£º
inµÄSQLÓï¾ä
SELECT id, category_id, htmlfile, title, convert(varchar(20),begintime,112) as pubtime
from tab_oa_pub WHERE ......
±¾ÎĽÚÑ¡×Ô¡¶Oracle DBAÊּǗ—Êý¾Ý¿âÕï¶Ï°¸ÀýÓëÐÔÄÜÓÅ»¯Êµ¼ù¡·µÚ2Õ“YangtingkunµÄDBA¹¤×÷Êּǔ £¨×÷ÕߣºÑîÍ¢çû£©
V$SQLÊÓͼÏÔʾ½á¹ûÒì³£µÄÕï¶Ï
ÓÐÒ»´ÎÅöµ½Ò»¸öºÜÆæ¹ÖµÄÎÊÌ⣬ÔÚ¼ì²é»á»°ËùÖ´ÐеÄSQLʱ£¬·¢ÏÖV$SQLÊÓͼÖÐSQL_TEXTÁÐÖеÄÊý¾ÝÊDz»Õý³£µÄ¡£
ÓÉÓÚV$SQLÊǶ¯Ì¬ÐÔÄÜÊÓͼ£¬ÀïÃæ±£´æµÄÊǵ± ......
ת×Ô:
http://blog.csdn.net/web_gus/archive/2004/10/11/132122.aspx
Select
ÓÃ;£º
´ÓÖ¸¶¨±íÖÐÈ¡³öÖ¸¶¨µÄÁеÄÊý¾Ý
Óï·¨£º
SELECT column_name(s) from table_name
½âÊÍ£º
´ÓÊý¾Ý¿âÖÐѡȡ×ÊÁÏÁУ¬²¢ÔÊÐí´ÓÒ»»ò¶à¸ö×ÊÁϱíÖУ¬Ñ¡È¡Ò»»ò¶à¸ö×ÊÁÏÁлò×ÊÁÏÐС£
SELECT
³ÂÊöʽµÄÍêÕûÓï·¨Ï൱ ......