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

VCʹÓÃSQLDMO²Ù×÷SQL Server

BOOL StartServer()
{
    if(FAILED(CoInitialize(NULL)))
    {
        AfxMessageBox(_T("Com³õʼ»¯Ê§°Ü"));
        return FALSE;
    }
    _SQLServerPtr spSQLServer;//¶¨ÒåSQL Server¶ÔÏóÖ¸Õë
    if(FAILED(spSQLServer.CreateInstance(__uuidof(SQLServer))))
    {
        AfxMessageBox(_T("ÎÞ·¨½¨Á¢SQL¶ÔÏó"));
        return FALSE;
    }
    CString strServer(_T("SQL Server·þÎñÆ÷Ãû³Æ"));
    CString strUserName(_T("µÇ½Ãû"));
    CString strPassword(_T("µÇ¼ÃÜÂë"));
    try
    {
        //³¬Ê±ÉèÖÃ
        spSQLServer->PutLoginTimeout(10);
        spSQLServer->PutApplicationName(_T("MyAppName"));
        spSQLServer->PutHostName(_T("MyHostName"));
        spSQLServer->PutNetPacketSize(1024);
        spSQLServer->Connect(_variant_t(strServer),_variant_t(strUserName),_variant_t(strPassword));
    }
    catch(_com_error pCE)
    {
        try
        {
            //Æô¶¯SQL Server·þÎñÆ÷
            spSQLServer->Start(FALSE,_variant_t(strServer),_variant_t(strUserName),_variant_t(strPassword));
        }
        catch(_com_error pCE)
        {
            AfxMess


Ïà¹ØÎĵµ£º

¼òµ¥µÄSQLÃæÊÔÌâ

1. Q. What is a join?
   A. Join is a process of retrieve pieces of data from different sets (tables) and returns them to the user or program as one joined collection of data.
2. Q. Can a table have more than one foreign key defined?
   A. A table can have any number of foreig ......

sqlÐÐתÁÐ


дһ¸ö´æ´¢¹ý³Ì£¬½«±íÒ»°´ÕÕ±í¶þµÄÐÎʽ½øÐвéѯ¡£
²Ö¿âÃû³Æ ÉÌÆ·Ãû³Æ ÊýÁ¿
A
S001 12
A S002 17
A
S003 10
B S001 21
B
S002 5
B S003 ......

java¡¢C#ÖÐSqlÓï¾ä´«²ÎµÄд·¨¼°ÒâÒå

 SqlserverÕⶫÎ÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ­¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾­¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......

SQL SERVERµÄÊý¾ÝÀàÐÍÁíÒ»°æ×ܽá

1.SQL SERVERµÄÊý¾ÝÀàÐÍ
¡¡¡¡Êý¾ÝÀàŪÊÇÊý¾ÝµÄÒ»ÖÖÊôÐÔ£¬±íʾÊý¾ÝËù±íʾÐÅÏ¢µÄÀàÐÍ¡£ÈκÎÒ»ÖÖ¼ÆËã»úÓïÑÔ¶¼¶¨ÒåÁË×Ô¼ºµÄÊý¾ÝÀàÐÍ¡£µ±È»£¬²»Í¬µÄ³ÌÐòÓïÑÔ¶¼¾ßÓв»Í¬µÄÌص㣬Ëù¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸ÷ÀàºÍÃû³Æ¶¼»ò¶à»òÉÙÓÐЩ²»Í¬¡£SQLServer ÌṩÁË 25 ÖÖÊý¾ÝÀàÐÍ£º
¡¡¡¡·Binary [(n)]
¡¡¡¡·Varbinary [(n)]
¡¡ ......

ÔÚVB2008 ËٳɰæÖÐʹÓòÎÊý»¯SQL²éѯÓï¾äÎÞЧ

  ×î½ü¸Õѧ»áÔÚVB2008 ÖÐʹÓòÎÊý»¯SQLÓï¾ä£¬ÓÚÊÇÂíÉÏÓõ½´úÂëÖУ¬È´Åöµ½²é²»µ½ÈκÎÊý¾ÝµÄÇé¿ö£¬¾À½áÁ˺ü¸Ì죬»¹ÊÇûÓиãÃ÷°×£¬²îµãÍÂѪ¡£²»µÃÒÑ»¹ÊÇÏÈÔÚ´úÂëÖÐʹÓÃ×Ö·û´®Æ´½ÓµÄSQLÓï¾ä¡£
  °üº¬²ÎÊý»¯SQLÓï¾äµÄ´úÂëÈçÏ£º
            Dim cmSl As N ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ