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ÌÐòÖеÄÔÒò°É,&ÓÐÎÊÌ⠸ijÉ#Õâ¸ö?²»ÖªµÀÊÇʲôÓïÑÔµÄ Â¥ÉϵÄÎÒÊÔ¹ýÁË»¹ÊDz»ÐÐ ÎÒÓõÄÊÇC++ ¼òµ¥µÄÆ´½Ó´íÎó¡£ C/C++ code: CString day="88888888"; ÉÏÃæÊÇÆäÒ»£¬Æä¶þ:
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
±íÈçÏ ½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ 101 50 08£º00 08£º30 30 40 50 101 50 09£º00 ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд ORACLEÖУº select floor(months_between(date1,date2)) from A date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ DB2ÖÐÈçºÎʹÓÃÐ ......
#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 ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ: id workbillno .................. 1 1 2 6 3 a1 4 c2 5 2 6 aa 7 ......