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

sqlserverͬʱµ¼³ö±í½á¹¹ºÍÊý¾Ý

ÓÃoracleϰ¹ßÁË£¬µ¼³öÓÃexpÓï¾ä£¬Ö±½ÓÉú³ÉdmpÎļþ£¬µ¼ÈëÓÃimpÓï¾ä£¬±í½á¹¹ºÍÊý¾Ýͬʱ¸ã¶¨¡£×î½üÐèÒªÓõ½sqlserver£¬×ÜÊDz»Äܹ»Í¬Ê±µ¼³ö±í½á¹¹ºÍÊý¾Ý£¬googleÉϰٶÈÁ˺ܾÃҲû½â¾ö·½·¨¡£
ÓÒ¼ü--ËùÓÐÈÎÎñ--µ¼³öÊý¾Ý--Ñ¡ÔñÊý¾ÝÔ´£¬Êý¾ÝԴΪÓÃÓÚSQLServerµÄMicrosoft OLE DBÌṩ³ÌÐò£¬Ñ¡ÔñÑéÖ¤·½Ê½


Ïà¹ØÎĵµ£º

SQLSERVER¼òµ¥´¥·¢Æ÷

 INSERT´¥·¢Æ÷
    INSERT¼°UPDATE´¥·¢Æ÷¾­³£ÓÃÓÚ¼ì²â´¥·¢Æ÷Ëù¼à¿Ø±íµÄÁм°ÆäÊý¾ÝÊÇ·ñ·ûºÏËù¶¨ÒåµÄ¹æÔò¡£ËüÃÇ¿ÉÒÔÔÚÊý¾ÝÊäÈë±í֮ǰ£¬¶ÔÆä½øÐÐÔÚ¶¨ÒåÒýÓÃÍêÕûÐÔʱÎÞ·¨Íê³ÉµÄÔ¼Êø¼ìÑé¡£
    ÏÂÃæÒÔѧÉúÊý¾Ý¿âstudentΪÀýÀ´½éÉÜINSERT´¥·¢Æ÷µÄʹÓ᣸ÃÊý¾Ý¿â°üÀ¨Èý¸ö±í£¬·Ö±ðÊÇÃèÊöѧÉúÇ ......

SQLSERVER ´æ´¢¹ý³Ì Óï·¨

*** author£ºSusan
*** date:2005/08/05
*** expliation:ÈçºÎ寫´æ儲過³ÌµÄ¸ñʽ¼°Àý×Ó£¬ÓÐÓÎ標µÄÓ÷¨£¡
*** ±¾°æ:SQL SERVER °æ£¡
******************************************************/
ÔÚ´æ儲過³ÌÖеĸñʽ規¸ñ£º
CREATE PROCEDURE XXX
/*
ÁÐ舉傳Èë ......

vc++ SQLServerÌí¼Ó²Ù×÷ʵÏÖ

/*
*SQLServerÌí¼Ó²Ù×÷ʵÏÖ
*/
void CMFCSQLDlg::OnButton2()
{
// TODO: Add your control notification handler code here
CString strsql;
CString strnum="mynum3";
CString strage="myage3";
HRESULT hResult;
_variant_t RecordsAffected;
CoInitialize(NULL);
_ConnectionPtr  m_pAppConn;
hResul ......

SQLSERVER ·ÖÒ³

select   identity(int,1,1) as col_id , *   into   temp   from  uep.dbo.A_experiment 
select   *   from temp where   col_id   between   50   and   60
drop  table temp ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ