Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çó½â£º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)   {
     


Ïà¹ØÎÊ´ð£º

MSSQLÊý¾Ý¿â±íÉè¼ÆÎÊÌ⣡

ÎÒÉè¼ÆµÄ
Óû§ÐÅÏ¢±í  ³­±íÊý¾Ý±í  ÀúÊ·³­±íÊý¾Ý±í
ÎÒµÄÏë·¨ÊÇ Ã¿Ô³õ  ϵͳ×Ô¶¯ÔÚ ³­±íÊý¾Ý±íÖÐÉú²ú ÓëÓû§¹ØÁªµÄÊý¾Ý ÓÃÓÚ³­±íÔ±µÄ¼È룬µ±³­±íԱȫ²¿Â¼Èëºó °ÑÊý¾ÝÈ«²¿¸´ÖƵ½ÀúÊ·±íÖРͨʱ ......

ÀàËÆ mssql select top ...µÄʵÏÖ

ÔÚms sqlserverÖУ¬È¡Âú×ãÌõ¼þµÄǰ¼¸ÐпÉÒÔʹÓÃselect topÓï¾ä£¬µ«ÔÚoracleÖв¢Ã»ÓÐÕâÑùµÄÓï¾ä£¬
ÎÒ´ÓÍøÉÏ¿´µ½ÁËÒ»ÖÖʵÏÖ

select * (select * from talbename) where rownum <=100 order by rownum as ......

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

asp+mssqlÈçºÎÈÃÒ»¸ö±í°´ÁíÒ»¸ö±íµÄÌõ¼þ½øÐвéÑ¯ÄØ£¿

±ÈÈç ±í1 ÓÐ
1
2
3
3ÌõÊý¾Ý

±í2ÓÐ
1  10
2  30
3  5

ÎÒÏëÈñí1°´±í2À´½µÐòÅÅÁУ¬¸ÃÈçºÎÐ´ÄØ£¿
2 ......

mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿

mssql ÀïµÄsystem_user ÔÚoracleÀïÓÐʲôµÈ¼Ûº¯Êý£¿
system_userÊä³öÊǵÄʲô£¿

µ±Ç°²Ù×÷µÄÓû§£¬ÄãÓÃʲôµÇ¼SQL Query Analyzer ¾ÍÊÇʲô

²»Á˽âmsqsl£¬Õâ¸öº¯ÊýÊÇÈ¡µ±Ç°Á¬½ÓuserµÄÂð£¿

Èç¹ûÊǵϰ ......

MSSQLÎÞ·¨Æô¶¯

===================================

ÎÞ·¨Á¬½Óµ½ .¡£

===================================

ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ