Çó½â£º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) {
 
Ïà¹ØÎÊ´ð£º
¸÷λ´óÏÀ£¬ÔÚsql server2000 ÖУ¬ÈçºÎµ¼Èë±í£¬ËûÀïÃæµÄ½á¹¹¶¼²»·¢Éú±ä»¯£¬ÏñË÷Òý£¬Ö÷¼üµÈ»¹ÊÇÔÀ´±íÀïµÄÉèÖã¬Èç¹ûÉú³Ésql½Å±¾µÄ»°£¬ÔÚ²éѯ·ÖÎöÆ÷ÀïÖ´ÐÐÒ»´Î£¬Ö÷¼üË÷Òý¶¼Ã»ÁË£¬ÓÐûÓкõİ취
±¸·Ý»¹Ô»òÕ߸½¼ÓÊÇΨ ......
MSSQL$SQLEXPRESS ÎÞ·¨Æô¶¯.. ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ лл
¿´¿´´íÎóÈÕÖ¾
Ìáʾʲô´íÎó?
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......
ĿǰÓбíAºÍ±íB
ÆäÖÐ×Ö¶ÎÏàͬ
±íAÖÐÖ÷¼üidΪ×ÔÔö³¤
²¢ÇÒΪ´óÊý¾ÝÁ¿´¢´æ
ÔõôÑùʹÓô洢¹ý³Ì¿ÉÒÔ½«±íAÖеÄÊý¾Ý±¸·Ýµ½±íBÖУ¬²¢ÇÒɾ³ý±íAÖб¸·Ý¹ýµÄÊý¾Ý
¸ßÊÖ¸øÒ»¸ö´æ´¢¹ýÊ££¬Ð»Ð»
·ÖÇø±í¿ÉÒÔ½«±íÖÐµÄ ......
ΪʲôMSSQLÖеÄGUIDÀàÐÍÓÐÁ½¸ö{xxxxxx}µÄ¡£²»·½±ã°¡¡£
µØÖ·´«ÖµµÄʱºòÕâÑùºÃ²»ºÃµÄ£¿
ĬÈÏÊä³öP¸ñʽ
-----------
ĬÈÏÊä³öÊÇB¸ñʽ...
ÉÏÃæËµÁË È¡³öÀ´¸ñʽ»¯Ò»ÏÂ
ѧϰÁË.
ÒýÓÃ
ĬÈÏÊä³ ......
ÎÒÓÐÒ»Êý¾ÝÊÇ´ÓLMS_DBÊý¾Ý¿â»Ö¸´³ÉÁíÒ»Êý¾Ý¿âERP_DB£¬½á¹û·¢ÏÖERP_DBÊý¾Ý¿âµÄÂß¼ÎļþÃû³Æ»¹ÊÇLMS_DBÃû³Æ£¬ÇëÎÊÔõÑùÐÞ¸ÄMS SQLÊý¾Ý¿âµÄÂß¼ÎļþÃû³Æ?
Ö±½Ó±¸·Ý³öÀ´¸Ä¸öÃû×ÖÊÔÊÔ
ALTER DATABASE
ALTER DATA ......