SQL³£±¸ÖªÊ¶
1¡¢SQLÂß¼²éѯ´¦ÀíÖеĸ÷¸ö½×¼¶Ë³Ðò
(8)SELECT (9) DISTINCT (11) <tOP_Specification> <select list>
(1)from¡¡£¼Left tables£¾
(3)<Join type>Join<Right_table>
(2) on <join conditions>
(4)WHERE <where conditions>
(5)GROUP BY <Group list>
(6)WITH {CUBE| Rollup}
(7)Having <Having conditions>
(10)ORDER BY
2¡¢Çå³ý»º´æ
dbcc dropcleanbuffers --Çå¿ÕËùÒÔÊý¾Ý
dbcc freeproccache ---Òª´Ó»º´æÖÐÇå³ýÖ´Ðмƻ®
dbcc flushprocindb(<db_id>)--Çå¿ÕÊý¾Ý¿âµÄÖ´Ðмƻ®
3¡¢STATISTICS IO--·µ»ØIOÐÅÏ¢
STATISTICS TIME--·µ»Ø·ÖÎö¡£±àÒë²éѯµÄʱ¼äÒÔ¼°Ö´Ðвéѯʱ¼ä
SET SHOWPLAN_TEXT ON--Îı¾¸ñʽִÐмƻ®
0
0
0
(ÇëÄú¶ÔÎÄÕÂ×ö³öÆÀ¼Û)
Ïà¹ØÎĵµ£º
1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
SELECT COUNT(*) from USER_TAB_COLUMNS WHERE TABLE_NAME=UPPER('pow_role')
ͳ¼Æpow_role±íµÄÁÐÊý
ÆäÖÐ USER_TAB_COLUMNS ÊÇϵͳ×Ô´øµÄ±í¡£
pow_roleÊÇҪͳ¼ÆµÄ±íÃû¡£
Èç¹ûҪͳ¼ÆÆäËûµÄ±íµÄÁÐÊýÖ»ÐèÒª°Ñ±íÃû»»Ò»Ï¾ͿÉÒÔÁË£¬Èç
SELECT COUNT(*) from USER_TAB_COLUMNS WHERE TABLE_NAME=UPPER('POW_ROLE_GROUP')&nb ......
ÔÚSQL ServerÖгöÓÚÊý¾Ý°²È«µÄ¿¼ÂÇ£¬ËùÒÔÐèÒª¶¨Æڵı¸·ÝÊý¾Ý¿â¡£¶ø±¸·ÝÊý¾Ý¿âÒ»°ãÓÖÊÇÔÚÁ賿ʱ¼ä»ù±¾Ã»ÓÐÊý¾Ý¿â²Ù×÷µÄʱºò½øÐУ¬ËùÒÔÎÒÃDz»¿ÉÄÜÒªÇó¹ÜÀíԱÿÌìÊص½ÍíÉÏ1µãÈ¥±¸·ÝÊý¾Ý¿â¡£ÒªÊµÏÖÊý¾Ý¿âµÄ¶¨Ê±×Ô¶¯±¸·Ý£¬×î³£Óõķ½Ê½¾ÍÊÇʹÓÃSQL Server´úÀíÖеÄ×÷Òµ¡£Æô¶¯SQL Server Agent·þÎñ£¬È»ºóÔÚÆäÖÐн¨×÷Òµ£¬×÷ÒµÖÐÌí¼ ......