Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôԭÒò°¡  Çë¸ßÊÖÖ¸½Ì
´æ´¢¹ý³ÌÓвÎÊýû??
Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......

¹ØÓÚoracleÊý¾Ý¿âÒÆÖ²µ½mssqlµÄÎÊÌâ.

ÆäÖÐÒ»¸öoracleÊý¾Ý¿âÖÐÆäÖÐÒ»¸ö±íÓжà¸öʱ¼ä´Á×Ö¶Î,mssqlÖ»ÄÜÔÊÐíÒ»¸öµÄ.
ʵÔÚÓÐÎÊÌâµÄ»°£¬ ¿ÉÒÔÏȽ¨Á¢ÁíÍâµÄÒ»ÕÅ±í£¬È»ºó°Ñtimestamp¸ÄΪdate£¬°ÑÊý¾Ý¸´ÖÆÒÔºó£¬ÔÚÒÆÖ²Ò»´Î


oracleµÄʱ¼ä´ÁºÏ²¢ÎªÒ»¸ö×ֶα ......

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

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

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

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

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

ÍøÕ¾´ò°ü£¬ÄÜ´ò³ÉmssqlµÄ±í²»Èÿͻ§¿´µ½ÄÚÈÝÂð

ÈçÌ⣬Ï뽫ÎÒÒÔǰ×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹý ......

ÇóÒ»¸ömssql±¸·ÝÊý¾Ý±íµÄ´æ´¢¹ý³Ì

ĿǰÓбíAºÍ±íB
ÆäÖÐ×Ö¶ÎÏàͬ
±íAÖÐÖ÷¼üidΪ×ÔÔö³¤
²¢ÇÒΪ´óÊý¾ÝÁ¿´¢´æ
ÔõôÑùʹÓô洢¹ý³Ì¿ÉÒÔ½«±íAÖеÄÊý¾Ý±¸·Ýµ½±íBÖУ¬²¢ÇÒɾ³ý±íAÖб¸·Ý¹ýµÄÊý¾Ý
¸ßÊÖ¸øÒ»¸ö´æ´¢¹ýÊ££¬Ð»Ð»
·ÖÇø±í¿ÉÒÔ½«±íÖÐµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ