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

C++ SQL SERVER ²åÈë±äÁ¿

int day=88888888;
pConn->Execute("INSERT  INTO  Information (day1)  values(  " & day & "  )",NULL,adCmdText);
Ϊʲô»á±¨´í£¿
        ¡°&¡±: ·Ç·¨£¬×ó²Ù×÷Êý°üº¬¡°const char [47]¡±ÀàÐÍ


ÁíÍâsql server Ôõô²ÅÄܲÅÊý¾Ý¿âµÄĩβ²åÈëÊý¾Ý£¿
--µ¥ÒýºÅÊÔÏÂ
INSERT  INTO  Information (day1)  values(  '& day & ' ),

²»ÐР ÎÒ²åÈëµÄintÀàÐ͵ıäÁ¿

SQL code:
insert into Information (day1) select day


pConn->Execute("INSERT  INTO  Information (day1)  values(  " & day & "  )",NULL,adCmdText);

ÄãÕâ¸öÊdzÌÐòÖеÄÔ­Òò°É,&ÓÐÎÊÌâ

ÒýÓÃ
pConn->Execute("INSERT  INTO  Information (day1)  values(  " & day & "  )",NULL,adCmdText);

ÄãÕâ¸öÊdzÌÐòÖеÄÔ­Òò°É,&ÓÐÎÊÌâ

¸Ä³É#Õâ¸ö?²»ÖªµÀÊÇʲôÓïÑÔµÄ

Â¥ÉϵÄÎÒÊÔ¹ýÁË»¹ÊDz»ÐÐ

ÎÒÓõÄÊÇC++

¼òµ¥µÄÆ´½Ó´íÎó¡£
C/C++ code:
CString day="88888888";


ÉÏÃæÊÇÆäÒ»£¬Æä¶þ:



Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

¸ÕѧC£¬ÓÃCʵÏÖ±àÂë - C/C++ / CÓïÑÔ

#include"stdio.h"
#include"stdlib.h"
void ContrTwo(char i)
{
char str1[8];
itoa(i,str1,2);
printf("%s",str1);
}
unsigned char leftRot(char str,int i);
unsign ......

SqlÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ