Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Server¹ÒÆð

ÔÚÔËÐд°¿ÚÊäÈëregedit£¬´ò¿ª×¢²á±í±à¼­Æ÷£¬ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session ManagerÖÐÕÒµ½PendingFileRenameOperations£¬É¾³ý¸Ã¼üÖµ£¬¹Ø±Õ×¢²á±í±à¼­Æ÷¡£ÖØÐ°²×°SQL Server 2000,´Ëʱ,¾Í¿ÉÒÔÕý³£½øÈëÆÚ´ýµÄ°²×°½çÃæÁË¡£ ......

SqlÓÅ»¯·½·¨

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......

sqlÓÅ»¯ ¶Ôlike ¡®%xx%¡¯ µÄÌæ»»

ÔÚSQLÖпÉÒÔʹÓÃLike½øÐÐÄ£ºý²éѯ£¬ÀýÈç f_stuname like 'a%' ²éѯf_stunameÁÐÒÔa¿ªÍ·µÄ¼Ç¼¡£
µ±ÎÒÃÇÔÚÓ¦ÓÃÖÐʹÓÃ
f_stuname
like '%a%' ʱ£¬Èç¹û

f_stunameÓÐË÷ÒýµÄ»°£¬Õâ¸öË÷ÒýÒ²ÊDz»Ö´ÐеÄ
ÔÚSQLÓÅ»¯ÖÐÕâ¸öд·¨¾ÍÊÇÒ»¸ö²»ºÃµÄSQLÁË¡£
ÄÇôÈçºÎÀ´Ìæ»»Õâ¸öÄØ£¬ÕâÒ»¸ö¾ÍÓõ½ÁËOracleµÄinstrº¯ÊýÁË
ÎÒÃÇ¿ÉÒÔÕâÑù ......

SQL½Å±¾×Ö¶Î[content]ºÍcontentÇø±ð

      ½ñÌìÎÒÔÚSQL Server 2005ÖÐÓýű¾´´½¨Ò»ÕÅ±í£¬²é×ÊÁÏ·¢ÏÖÓеĽű¾ÖÐ×Ö¶ÎÓмÓ[]ÖзûºÅ£¬ÎÒÎÊÁ˶¬¼¾£¬µÃÖªÊÇÕâ»ØÊ£¬ÓÃ[]µÄ×Ö¶ÎÃû£¬¼´±ãÊÇsql¹Ø¼ü×ÖÒ²¿ÉÒÔ×÷Ϊ×Ö¶ÎÃû£¬²»»á±¨´í¡£
      SQL ServerÀïµÄ±íÖÐÌí¼ÓÒ»¸ö×ֶΣ¬È磺timeϵͳ»á×Ô¶¯¼ÓÒ»¶Ô·½À¨ºÅ¼´£º[time] ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ