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

VC++µÄADOÁ¬½ÓSQL Server²½Öè

 1£ºSQL  ServerÊý¾Ý¿âÅäÖÃ
 
 
 
¿ªÆô·þÎñÆ÷
 
 
ÍÐÅÌÏÔʾ·þÎñÆ÷Æô¶¯
 
 
 
2:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace      rename("EOF","adoEOF")rename("BOF","adoBOF")
 
//³öÏÖmsado15.dll ±íʾµ¼Èë³É¹¦
 
 
 
 
 
 
3:ÔÚBOOL  CXXXApp::InitInstance()Öгõʼ»¯COM»·¾³
BOOL CXXXApp::InitInstance()
{
       AfxEnableControlContainer();
    ::CoInitialize(NULL);  
    …….
    ÊÍ·ÅCOM»·¾³
    ::CoUninitialize();
    return FALSE;
}
  
 
 
4£ºËµÃ÷
   ÀûÓÃϵͳĬÈ϶¨ÒåÈ«¾ÖCXXXAppÀàµÄ¶ÔÏótheApp¿ÉÒÔµ÷ÓÃÀà·½·¨£¨º¯Êý£©µÄÄÜÁ¦£¬
   ¹ÊÔÚCXXXAppÀàÖмÓÈëÁ¬½ÓÊý¾Ý¿âµÄ¹«¹²·½·¨—InitADOConn£¨£©ºÍ¹«¹²Êý¾Ý—  
   _ConnectionPtr  m_pConnection¡£
 
 
 
 
5£ºInitADOConn£¨£©µÄÄÚ²¿ÊµÏÖ
      
   void CXXXApp::InitADOConn()
{
          //ÓÃÓÚÈ«¾Ö±äÁ¿µ÷ÓÃÁ¬½ÓÊý¾Ý¿â
      
          HRESULT hr;    //·µ»Ø¼´½á¹û±äÁ¿
          try
          {
               hr=m_pConnection.CreateInstance("ADODB.Connection"); //³õʼ»¯Á¬½Ó×Ö·û¼¯
             
              if(SUCCEEDED(hr))
                 {
            &nbs


Ïà¹ØÎĵµ£º

SQLÖÐobject_idº¯ÊýµÄÓ÷¨

 ¾­³£»á¿´¼ûÔÚSQL³ÌÐòµÄ¿ªÍ·ÓÐÕâÑùÒ»¾ä»°
if OBJECT_ID('tb') is not null
drop table tb  
º¯ÊýÓï·¨ÊÇÕâÑù£º
int OBJECT_ID('objectname');
×÷ÓÃÊÇ¿´¶ÔÏóobjectnameÊÇ·ñ´æÔÚ¡£
ÆäÖвÎÊýobjectname±íʾҪʹÓõĶÔÏó£¬ÊÇchar»òÕßncharÀàÐÍ¡£
·µ»ØÖµÀàÐÍΪint£¬Èç¹û¶ÔÏó´æÔÚ£¬Ôò·µ»Ø´Ë¶ÔÏóÔÚϵͳÖеı ......

C++&wxWidgets ¿çƽ̨´°¿Ú³ÌÐò¿ª·¢(¶þ,Linuxƪ)

ÎÒÓõÄLinuxϵͳÊÇUbuntu 10.04
Ê×ÏÈ, °²×°wxWidgets 2.8. ĿǰwxWidgetsÓÐÁ½¸öÎȶ¨°æ±¾, 2.6ºÍ2.8, ÎÒÃÇÑ¡×îеÄ. ´ò¿ª “Ubuntu
Èí¼þÖÐÐÄ”, ÔÚËÑË÷¿òÀïÊäÈë “wxWidgets”, °ÑÏÂÃæ¼¸¸öÃû×ÖÒÔ”wxWidgets Cross-platform C++ GUI
toolkit”¿ªÍ·µÄÈ«²¿°²×°. ×°Íêºó, ´ò¿ªÒ»¸öÖÕ¶Ë, ÊäÈ ......

SQLÓïÑÔ»ù´¡ Êý¾Ý¶¨Òå

1¡¢¶¨Òå»ù±¾±í
SQLÓïÑÔʹÓö¯´ÊCREATE¶¨Òå»ù±¾±í£¬Æä¾ßÌåÓï·¨¸ñʽÈçÏ£º
CREATE TABLE <±íÃû>
(<ÁÐÃû><Êý¾ÝÀàÐÍ>[Áм¶ÍêÕûÐÔÔ¼ÊøÌõ¼þ]...[£¬<ÁÐÃû><Êý¾ÝÀàÐÍ>[Áм¶ÍêÕûÐÔÔ¼ÊøÌõ¼þ]][,<±í¼¶ÍêÕûÐÔÔ¼ÊøÌõ¼þ>])£»
ÀýÈ磺½¨Á¢Ò»¸öѧÉú±íStudent£¬ËüÓÉѧºÅSno£¬ÐÕÃûSname£¬ÐÔ±ðSsex£¬Äê ......

SQLÓïÑÔ»ù´¡ Êý¾Ý²éѯ

ÔÚSQLÓïÑÔÖУ¬Ö»ÌṩÁËÒ»¸ö¶¯´ÊSELECTÓÃÀ´½øÐÐÊý¾Ý²éѯ²Ù×÷£¬µ«Õâ¸ö¶¯´ÊµÄ²ÎÊýÊ®·Ö¸´ÔÓ£¬ÇÒÄÜǶÌ×ʹÓã¬ÆäͨÓøñʽÈçÏ£º
SELECT [All|Distinct]<Ä¿±êÁбí´ïʽ>[£¬<Ä¿±êÁбí´ïʽ>]...
from <±íÃû»òÊÓͼÃû>[£¬<±íÃû»òÊÓͼÃû>]...
[WHERE<Ìõ¼þ±í´ïʽ>]
[GROUP BY<ÁÐÃû1>[HAVING<Ì ......

Rebuild indexes online with SQL Server 2005

Rebuild indexes online with SQL Server 2005
http://blogs.techrepublic.com.com/datacenter/?p=249
Online index rebuild
SQL Server 2005 introduces the ability to rebuild your indexes in an
online fashion so that other processes are able to access the table
while the rebuild is occurring. Because y ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ