Çó½â£ºQT4.5.3 Á¬½ÓMSSQL³É¹¦£¬Ö´ÐÐÓï¾ä³ö´í
´úÂëÈçÏ£º
QSqlDatabase dbconn = QSqlDatabase::database( "sqltest ", false);
if(!dbconn.isValid()) {
dbconn = QSqlDatabase::addDatabase( "QODBC ", "sqltest ");
QString dsn = QString( "Driver={sql server};server=localhost;database=Test;uid=sa;pwd=sa ");
dbconn.setDatabaseName(dsn);
dbconn.setHostName(QString( "localhost "));
dbconn.setPort(1433);
dbconn.setDatabaseName(QString( "Test "));
dbconn.setUserName(QString( "sa "));
dbconn.setPassword(QString( "sa "));
}
bool r = dbconn.open();
if (r) {
 
Ïà¹ØÎÊ´ð£º
ÎÒÉè¼ÆµÄ
Óû§ÐÅÏ¢±í ³±íÊý¾Ý±í ÀúÊ·³±íÊý¾Ý±í
ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ ϵͳ×Ô¶¯ÔÚ ³±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³±íÔ±µÄ¼È룬µ±³±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......
ÔÚms sqlserverÖУ¬È¡Âú×ãÌõ¼þµÄǰ¼¸ÐпÉÒÔʹÓÃselect topÓï¾ä£¬µ«ÔÚoracleÖв¢Ã»ÓÐÕâÑùµÄÓï¾ä£¬
ÎÒ´ÓÍøÉÏ¿´µ½ÁËÒ»ÖÖʵÏÖ
select * (select * from talbename) where rownum <=100 order by rownum as ......
asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿
±ÈÈç ±í1 ÓÐ
1
2
3
3ÌõÊý¾Ý
±í2ÓÐ
1 10
2 30
3 5
ÎÒÏëÈñí1°´±í2À´½µÐòÅÅÁУ¬¸ÃÈçºÎÐ´ÄØ£¿
2 ......
mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿
system_userÊä³öÊǵÄʲô£¿
µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô
²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂð£¿
Èç¹ûÊǵϰ ......
===================================
ÎÞ·¨Á¬½Óµ½ .¡£
===================================
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐ ......