Çó¸ösqlº¯Êý - MS-SQL Server / »ù´¡Àà
SQL code:
<p align="center"><img title="2222222222222" height="200" alt="2222222222222" src="../UpLoadFolder/201056221026166491.gif" width="200" border="0" /></p>
ÓÐÕâÖÖÀàÐ͵Ä×Ö·û´®
ÎÒÏë°ÑÀïÃæµÄ 201056221026166491.gif »òÕß ../UpLoadFolder/201056221026166491.gif
ÕâÑùµÄ×Ö·û´®ÄóöÀ´Ê¹ÓÃ
Ó¦¸ÃÈçºÎдsql°¡
Õâ¸ö»¹ÊÇÈ¥C#ÀïÃæÎÊÕýÔò°É,
û¸ö¾ßÌ广ÂÉ,SQLÄѸã
SQL code:
declare @s varchar(1000)
set @s='<p align="center"><img title="2222222222222" height="200" alt="2222222222222" src="../UpLoadFolder/201056221026166491.gif" width="200" border="0" /></p>'
select LEFT(col,charindex('"',col)-1) as col from (select stuff(@s,1,charindex('../',@s)-1,'') as col) t
/*
col
------------------------------------------------
../UpLoadFolder/201056221026166491.gif
(1 ÐÐÊÜÓ°Ïì)
*/
SQL code:
declare @s varchar(1000)
set @s='<p align="center"><img tit
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
ÓÐ2¸öÊý¾Ý±íAÓëB£¬ÈçºÎ²¹³äAÖÐûÓÐ,BÖÐÓеÄÊý¾Ý£¬Ê¹A±íÊý¾ÝÍêÕû£¿ÇëдϾßÌåÔ´´úÂë
SQL code:
insert A select * from A right join B on A.key=b.key where A.key is null
select * from B left join ......