Ôõô½«´øÌØÊâ×Ö·ûµÄ×Ö·û´®´æÈësqlserverµÄij¸ö×ֶΣ¿
Java code:
Ôõô½«ÏñÏÂÃæµÄ´øÌØÊâ×Ö·û(µ¥ÒýºÅ¡¢°Ù·ÖºÅ£¬Ë«ÒýºÅ£¬#ºÅ£¬ÃÀÔª·ûºÅ......)µÄ×Ö·û´®´æÈësqlserverµÄij¸ö×ֶΣ¿
String mystring="
insert into T_PUB_RZGL(N_RZID,N_RZLX,N_BMDM,N_YGGH,C_RZNR,C_RZSJ) values(10,6,9,412,'¸üÐÂÎÄ×Ö×ÊÁÏ,id£º'112' ¹ØÁªµ½Æ±Æ·¼ò³Æ£º325000',replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':',''))
"
Java code:
strSql = " insert into T_PUB_RZGL(N_RZID,N_RZLX,N_BMDM,N_YGGH,C_RZNR,C_RZSJ)" +
" values(" + iId + ","+strRzlx+","+strBmdm+","+strYggh + ",'"+ mystring +"','ʱ¼ä')
i=stmt.executeUpdate(strSql );
sqlserverÓÐûÓÐÏñPHPÄÇÑù½«sqlÓï¾ä¸ñʽ»¯Îª¿É´æ´¢×Ö·û´®µÄº¯Êý£¿
¼ÓN''
SQL code:
ESCAPE
¾ÍÊǵ¥ÒýºÅÒª´æÈëʱ ÓÃÁ½¸ö
declare @s varchar(10)
set @s = 'adfasdf''sadfasdfadf'
×¢ÒâÖмäµÄÁ½¸ö''
µ¥ÒýºÅµÄ»°,ÊÇÁ½µã±íÒ»µã,
SELECT ''''
ÕâÑùSQL code:
Ïà¹ØÎÊ´ð£º
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
Order by ʱ¼ä×Ö¶Î desc
ÅŲ»ÁË˳ÐòÁË
ǰÌáÊÇÎÒÕâ¸öÊÇÒ»¸öÊÔͼ£¿
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡£¡ºÜÊÇÓôÃÆ£¡Ï£Íû¸÷Ϊ¸ßÊÖÖ¸µã£¡£¡
¼±¼±£¡£¡£¡£¡
ËûÔÚÐÞ¸ÄÊ ......
C# code:
string strCmd = "SELECT Top 0 * from tabAreaStationData";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(strCmd, sqlCn);
DataTable dt = new DataTable(); ......
ERPÈí¼þµÄÊý¾Ý¿âÊÇSQLSERVER2000µÄ£¬¹«Ë¾ÈÃÎÒ×ö¸öÍøÕ¾£¬ÆäÖÐÓÐЩÊý¾ÝÊǵ÷ÓÃERPÀïµÄ£¬ÎÒÏëÓÃPHP×öÍøÕ¾£¬µ«ÊDz»ÖªµÀPHP·ÃÎÊSQLSERVER¿âºÃʵÏÖ²»£¬ÔÙ¾ÍËÙ¶È·½ÃæÓ°Ïì²»»áÌ«´ó°É£¿¸úASP·ÃÎÊSQLSERVERÏà±ÈËٶȱ仯´ó²»£¿£¨ ......