sql INSERT ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
pCmd->CommandText="insert into userftprequest(filename,telnoid,telno,indatetime,productid,dealdatetime,activedatetime,canceldatetime,doflag) values( '"+file_name+"','"+telnoid+"','"+telno+"',todate('"+indatetime+"','YYYY-MM-DD HH24:MI:SS'),'"+productid+"',todate('"+dealdatetime+"','YYYY-MM-DD HH24:MI:SS'),todate('"+activedatetime+"','YYYY-MM-DD HH24:MI:SS'), todate('"+canceldatetime+"','YYYY-MM-DD HH24:MI:SS'),'"+doflag+"')";
ÕâÀﱨ´í
error C2678: ¶þ½øÖÆ¡°+¡± : ûÓÐÕÒµ½½ÓÊÜ¡°std::basic_string<_Elem,_Traits,_Ax>¡±ÀàÐ͵Ä×ó²Ù×÷ÊýµÄÔËËã·û(»òûÓпɽÓÊܵÄת»»
-- ºÜÂÒ£¬Ã»·¨¿´!
´òÓ¡ÏÂÕâ¸ö×Ö·û´®pCmd->CommandText £¬ÔÚPLSQLÖпÉÒÔÖ´ÐÐÂð£¿
±¨´í ²»ÄÜÖ´ÐдòÓ¡
insert into userftprequest(filename,telnoid,telno,indatetime,productid,dealdatetime,activedatetime,canceldatetime,doflag£©
values( '"+file_name+"','"+telnoid+"','"+telno+"',
todate('"+indatetime+"','YYYY-MM-DD HH24:MI:SS'),
'"+productid+"',todate('"+dealdatetime+"','YYYY-MM-DD HH24:MI:SS'),
todate('"+activedatetime+"','YYYY-MM-DD HH24:MI:SS'),
todate('"+canceldatetime+"','YYYY-MM-DD HH24:MI:SS'),'"+doflag+"')";
Õâ²»»áºÜÂÒ°É
°ïæ¿´ÏÂÁË Ð»Ð»
todate('"+canceldatetime+"','YYYY-MM-DD HH24:MI:SS'),'"
Ïà¹ØÎÊ´ð£º
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......