Çó½â£º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) {
 
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec proc_showresult.
¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôÔÒò°¡ Çë¸ßÊÖÖ¸½Ì
´æ´¢¹ý³ÌÓвÎÊýû??
Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......
Çë¿´ÒÔÏÂÀý×Ó Ð»Ð»£¡
Àý×Ó
A(×Ö¶Î)
------------------------
a b c
ab c
f c d
½á¹û:
A(×Ö¶Î)
------------------------È ......
Ò»¸öÊý¾Ý¿â±í ÀïÃæµÄ×Ö¶ÎÓÐ VIPÓû§AÀà VIPÓû§bÀà VIPÓû§cÀà VIPÓû§dÀà VIPÓû§eÀà VIPÓû§fÀà ¡£¡£¡£
ÀïÃæµÄÊý¾Ý¶¼Êǵ绰ºÅÂë ......
mssqlµÄ´æ´¢¹ý³ÌÀïÔõô»ñµÃÒ»ÌõSQLÓï¾äµÄÖ´ÐÐ״̬Êdzɹ¦»¹ÊÇʧ°Ü£¿ÎÒÏëÔÚÒ»ÕűíÖÐÔö¼Ó¼Ç¼£¬Ê×ÏÈÒª¼ì²éÊÇ·ñÒѾ´æÔÚÏàͬ¼Ç¼£¬Èç¹û´æÔھ͸üУ¬·ñÔò¾Í²åÈë¡£
ÎÒ¾ÍÏëÏÈÊÔÊÔ²åÈë²Ù×÷£¬Ê§°ÜÁ˾ÍÈ¥¸üУ¬»òÕßÏÈÈ¥¸üР......
===================================
ÎÞ·¨Á¬½Óµ½ .¡£
===================================
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐ ......