Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 job²»ÄÜÖ´ÐÐ

¸÷λ´óÏÀ  £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec  proc_showresult.
¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôԭÒò°¡  Çë¸ßÊÖÖ¸½Ì
´æ´¢¹ý³ÌÓвÎÊýû??
Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......

Çë½Ì¸ßÊÖMSSQLÈ¥¿Õ¸ñÎÊÌ⣿THK£¡

Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó

    A(×Ö¶Î)
------------------------
a b  c
ab  c
f c d


½á¹û:

    A(×Ö¶Î)
------------------------È ......

¸ßÊÖ½ø¡£¡£mssqlµÄÒ»¸öÄÑÌâ...¼±...Çó¾È¡£¡£¡£

  Ò»¸öÊý¾Ý¿â±í ÀïÃæµÄ×Ö¶ÎÓР VIPÓû§AÀà  VIPÓû§bÀà  VIPÓû§cÀà  VIPÓû§dÀà  VIPÓû§eÀà  VIPÓû§fÀà  ¡£¡£¡£ 
    ÀïÃæµÄÊý¾Ý¶¼Êǵ绰ºÅÂë ......

MSSQL´æ´¢¹ý³Ì

mssqlµÄ´æ´¢¹ý³ÌÀïÔõô»ñµÃÒ»ÌõSQLÓï¾äµÄÖ´ÐÐ״̬Êdzɹ¦»¹ÊÇʧ°Ü£¿ÎÒÏëÔÚÒ»ÕűíÖÐÔö¼Ó¼Ç¼£¬Ê×ÏÈÒª¼ì²éÊÇ·ñÒѾ­´æÔÚÏàͬ¼Ç¼£¬Èç¹û´æÔھ͸üУ¬·ñÔò¾Í²åÈë¡£
ÎÒ¾ÍÏëÏÈÊÔÊÔ²åÈë²Ù×÷£¬Ê§°ÜÁ˾ÍÈ¥¸üУ¬»òÕßÏÈÈ¥¸üР......

MSSQLÎÞ·¨Æô¶¯

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

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

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

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