QTPÊý¾Ý¿â¼ì²éµãÊÖ¶¯SQLд·¨
Ò»¡¢SQL Server¸ñʽ(±¾µØÎÞÐè°²×°SQL Server)
connectionstring(Á¬½Ó×Ö·û´®):
1.±¾µØûÓд´½¨Êý¾ÝÔ´µÄ·½Ê½
DRIVER=SQL Server;SERVER=Êý¾Ý¿âIPµØÖ·;UID=Óû§Ãû;PWD=ÃÜÂë;APP=Microsoft Office 2003;WSID=±¾µØÖ÷»úÃû;DATABASE=Êý¾Ý¿âÃû
ʵÀý£º
DRIVER=SQL Server;SERVER=10.160.11.10;UID=sa;PWD=sa;APP=Microsoft Office 2003;WSID=RJHLJUN;DATABASE=dcwork
2.±¾µØÒÑ´´½¨Êý¾ÝÔ´µÄ·½Ê½
DSN=Êý¾ÝÔ´Ãû³Æ;UID=Óû§Ãû;PWD=ÃÜÂë;APP=Microsoft Office 2003;WSID=Êý¾Ý¿âµÄÖ÷»úÃû;DATABASE=Êý¾Ý¿âÃû
ʵÀý£º
DSN=LocalServer;UID=sa;PWD=sa;APP=Microsoft Office 2003;WSID=RJDCWORKTEST;DATABASE=dcwork
3.SQLÓï¾äʵÀý(´ÓÊý¾Ý¿â±íHR_LANGUAGE_TYPEÖУ¬²éѯ×Ö¶ÎÓïÑÔÃû³ÆLANGUAGE_NAME£¬Ìõ¼þÓïÑÔÃû³Æ£½ÖÐÎÄ£¬°´ÓïÑÔÃû³ÆÉýÐòÅÅÐò½á¹û)
source(SQLÓï¾ä):
SELECT
HR_LANGUAGE_TYPE.LANGUAGE_NAME from dcwork.dbo.HR_LANGUAGE_TYPE
HR_LANGUAGE_TYPE WHERE (HR_LANGUAGE_TYPE.LANGUAGE_NAME='ÖÐÎÄ') ORDER BY
HR_LANGUAGE_TYPE.LANGUAGE_NAME
¶þ¡¢DB2¸ñʽ£º(±¾µØÖÁÉÙ°²×°DB2 Run-Time Client Lite)
connectionstring(Á¬½Ó×Ö·û´®):
1.±¾µØûÓд´½¨Êý¾ÝÔ´µÄ·½Ê½
DRIVER={IBM DB2 ODBC DRIVER};UID=Óû§Ãû;PWD=ÃÜÂë;MODE=SHARE;DBALIAS=Êý¾Ý¿âÃû;
ʵÀý£º
DRIVER={IBM DB2 ODBC DRIVER};UID=db2admin;PWD=db2admin;MODE=SHARE;DBALIAS=DCWORK;
2.±¾µØÒÑ´´½¨Êý¾ÝÔ´µÄ·½Ê½
DSN=Êý¾ÝÔ´Ãû³Æ;UID=Óû§Ãû;PWD=ÃÜÂë;MODE=SHARE;DBALIAS=DCWORK;
ʵÀý£º
DSN=DWCORKDB2;UID=db2admin;PWD=db2admin;MODE=SHARE;DBALIAS=DCWORK;
3.SQLÓï¾äʵÀý
source:SQLÓï¾ä
SELECT
HR_LANGUAGE_TYPE.LANGUAGE_NAME from DB2ADMIN.HR_LANGUAGE_TYPE
HR_LANGUAGE_TYPE WHERE (HR_LANGUAGE_TYPE.LANGUAGE_NAME='ÖÐÎÄ') ORDER BY
HR_LANGUAGE_TYPE.LANGUAGE_NAME
Èý¡¢Oracle¸ñʽ£º
connectionstring(Á¬½Ó×Ö·û´®):
1.±¾µØûÓд´½¨Êý¾ÝÔ´µÄ·½Ê½
DRIVER={Oracle
in
OraHome92};SERVER=Êý¾Ý¿â·þÎñÃû;UID=Óû§Ãû;PWD=ÃÜÂë;DBQ=Êý¾Ý¿âÃû;DBA=W;APA=T;EXC=F;
XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;MTS=F;MDI=Me;CSR=F;FWC=F;PFC=10;TLO=O;
´ò¿ªQTP
1.insert--checkpoint--database checkpoint
2.ÔÚµ¯³öÀ´µÄ´°¿ÚÑ¡ÔñµÚ¶þÏî specify SQL ....,È
Ïà¹ØÎĵµ£º
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
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 ......
Èç¹ûÄã¾³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLÏ°¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......
1. ²é¿´oracleÊý¾Ý¿â×Ö·û¼¯£º
select userenv('language') from dual;
2. ÇåÆÁ ÔÚOracle Sql/PlusÖÐ
clear scr;
clear screen;
3. ²éѯµ±Ç°Óû§Ï¶¼ÓÐÄÇЩ±í
select * from tab;
4.&n ......
(ËÄ)ÆäËûÊéÉÏûÓеÄË÷ÒýʹÓþÑé×ܽá
¡¡¡¡1¡¢ÓþۺÏË÷Òý±ÈÓò»ÊǾۺÏË÷ÒýµÄÖ÷¼üËٶȿì
¡¡¡¡ÏÂÃæÊÇʵÀýÓï¾ä£º(¶¼ÊÇÌáÈ¡25ÍòÌõÊý¾Ý)
¡¡¡¡select gid,fariqi,neibuyonghu,reader,title from Tgongwen
¡¡¡¡where fariqi='2004-9-16'
¡¡¡¡Ê¹ÓÃʱ¼ä£º3326ºÁÃë
¡¡¡¡select gid,fariqi,neibuyonghu,reader,title from Tgongwe ......