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

MSSqlÊý¾Ý¿â±»¹ÒÂí

ÏÖÓÐÒ»¸öASP+mssqlµÄÍøÕ¾£¬±»¹ÒÂíÁË£¬½«ÀïÃæÒ»¸ö±íÖеÄntext×ֶιÒÂí¹ÒÂí£¬¡°<script src=http://ľÂíµØÖ·></script>¡±,µÄ·½Ê½ÊÇ£¬²»¶ÏµØÐ޸ĸÃ×ֶεÄÖµ£¬Ö±½Ó¼ÓÔÚ×îºóµÄ£¬Ê±¼ä³¤ÁË£¬¿ÉÒÔ¿´µ½¸Ã×Ö¶ÎÖÐÓкܶà¸öÁ¬ÐøµÄ¡°<script src=http://ľÂíµØÖ·></script>¡±,Ò²¿´ÁËÍøÉϵÄһЩ½â¾ö°ì·¨£¬µ«ÊÔÁËûÓУ¬±ÈÈç˵½«Ô­À´µÄID×Ö¶ÎÒѾ­¸Ä³ÉÆäËûÃû×ÖÁË£¬±íÃûÒ²¸ÄÁË£¬µ«ÈÔÈ»ÊÇÒ»»áÓÖ±»¹ÒÉÏÁË£¬¶øÇÒ¶Ô´«ÈëµÄIDÖµÒ²½øÐÐÁËÅжϣ¬¼´½«Ô­À´µÄ
id=request("ID")¶¼ ¸Ä³ÉÁËaaa_id=cint(request("ID")),ͬʱ½«±íÖеÄID×Ö¶ÎÃû¸Ä³ÉÁËaaa_id£¬»¹ÊǺܿ챻¹ÒÂí
Õæ²»ÖªÈçºÎ½â¾öÁË¡£
Êý¾Ý¿âÖÐÓкܶà±íÖж¼ ÓÐntextÀàÐ͵Ä×ֶΣ¬µ«ÏÖÔÚ¾ÍÖ»·¢ÏÖÓÐÒ»¸ö±íÖÐÀÏÊDZ»¹ÒÂí¡£
Õâµ¹µ×ÊÇÔõô»ØÊ£¿
Ôõô»ØÊÂÒª¿´ÄãÉæ¼°µ½Õâ¸ö±íµÄASP³ÌÐò

http://topic.csdn.net/u/20090729/14/26381958-0d6e-4b90-bc90-d275e9621f93.html

Êý¾Ý¿â±»×¢Èë¹¥»÷ ËùÓÐÎı¾ÐÍ×Ö϶ÎÊý¾Ý¶¼±»¼ÓÁË <script_src=http://ucmal.com/0.js> </script>
Ôõôɾµô£¿

SQL code:

--sql 2000½â¾ö·½·¨
DECLARE @fieldtype sysname
SET @fieldtype='varchar'

--ɾ³ý´¦Àí
DECLARE hCForEach CURSOR GLOBAL
FOR
SELECT N'update '+QUOTENAME(o.name)
+N' set '+ QUOTENAME(c.name) + N' = replace(' + QUOTENAME(c.name) + ',''<script_src=http://ucmal.com/0.js> </script>'','''')'
from sysobjects o,syscolumns c,systypes t
WHERE o.id=c.id
AND OBJECTPROPERTY(o.id,N'IsUserTable')=1


Ïà¹ØÎÊ´ð£º

mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿

mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»

SQL code:
select distinct *
from tablename
where id in (
selec ......

mssql ÕæµÄ·Ç³£²î!

¿ªÈý¸öÏß³ÌÅÜÏÂÃæµÄÕâ¸ö Do() º¯Êý¾Í»á·¢ÉúËÀËø.
¿ªÈý¸öÏß³ÌÒÔÉÏ,¾Í¸ù±¾Åܲ»ÆðÀ´!.
²»¾ÍÊǶÔͬһÖ÷´Ó±í½øÐÐÔöɾ¸Ä²Ù×÷ô.¾Í1000ÌõÒ²»áÕâÑù,Ì«²îÁË!

C# code:

public void Do()
{ ......

mssqlÖ´Ðд洢¹ý³Ì×ÊÔ´²»×㲿·Ö½á¹ûÒѱ»É¾³ý

ÎÊÌâÈçÉÏ£¬ÔÚÖ´Ðд洢¹ý³ÌµÄʱºòÖ´ÐÐÍêÁË£¬½á¹ûûɶÎÊÌ⣬¾ÍÊÇÌáʾÓдíҲûÓдíÎó´úÂë¾ÍÊǵ¯³ö¸ö¿ò¿ò¡°×ÊÔ´²»×㣬²¿·Ö½á¹ûÒѱ»É¾³ý¡±£¬´ó¼ÒÓо­ÑéµÄ¸ø¿´¿´¿ÉÄÜÊÇʲôԭÒò£¬Ð»Ð»ÁË
×ÊÔ´²»×ã ÏÔʾ²»ÏÂÁË Ã»É¶ÎÊÌâ°É
......

Ò»¸öÁ¬½ÓmysqlºÍmssqlµÄ×¢²á¹¦ÄÜ£¡100·Ö

Ìṩһ¸öÍêÕûµÄ¼òµ¥Ê¾Àý
µã»÷×¢²áµÄʱºò£¬°ÑÐÅϢͬʱע²áµ½mysqlµÄA±íºÍmssqlµÄA±í лл
×¢²á¹¦ÄÜ?? ÊÇʲôÒâ˼


ÒýÓÃ
PHP code//Á¬½Ómysql$insertmysql="insert into A values('$name', ......

MSSQL UTF8ÖÐÎÄÂÒÂë

Ò³ÃæºÍPHP³ÌÐò¶¼ÊÇUTF8±àÂëµÄ£¬mssql 2005ÓõÄÊÇchinese_rpc_ai_csÅÅÐò¹æÔò£¬Ìý˵ÕâÀï¿ÉÒÔÉèÖÃÊý¾Ý¿âµÄ×Ö·û¼¯¡£
ÎÒÓÃphp³ÌÐò²åÈëÊý¾Ý£¬²åÈë½øÈ¥µÄÖÐÎͼÊÇÂÒÂ룬ÓеϹÎÞ·¨²åÈë¡£¶ÁÈ¡³öÀ´µ¹ÊÇÕý³£¡£
ÇëÎʸÃÔõà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ