SQL Enlight 1.5 ÆÆ½â µÚ¶þ°æ
SQL Enlight 1.5 ÆÆ½â µÚ¶þ°æ ÊÕ²Ø
ÆÆ½âÉùÃ÷£ºÎÒµÄÆÆ½â½öÓÃÓÚÑо¿£¬ÇëÎðÓÃÓÚÉÌÒµÓÃ;£¬ÐèҪʹÓÃÇ빺ÂòÕý°æÈí¼þ¡£
¿É¶ñµÄUbitSoft£¬ÎÒµÄÆÆ½â³öÀ´»¹Ã»¼¸Ì죬ËûµÄ³ÌÐò¾Í¸Ä±äÁËÑéÖ¤Âß¼£¬ËäÈ»ÎÒ¾õµÃSQL EnlightµÄ¹¦Äܲ»ÊǷdz£Ç¿´ó£¬µ«ÊÇËûµÄ·ÀÆÆ½â¹¦Äܵ¹ÊÇÏÂÁ˲»ÉÙ¹¦·ò£¬³ýÁ˺ËÐÄ´úÂëÓÃvc++.net±àдµÄnative codeºÍil code»ìºÏµÄ×é¼þ£¬»¹ÔÚ³ÌÐòÂß¼Öе÷ÓÃÁË.netÖ´ÐÐÒýÇæµÄStrongNameSignatureVerificationEx·½·¨ÑéÖ¤µ÷ÓóÌÐò¼¯µÄÇ¿ÃüÃûÊÇ·ñÓÐЧ£¬ËùÒÔ¼òµ¥µÄ·´±àÒëSQL EnlightµÄ×é¼þ£¬²¢ÈƹýÇ¿ÃüÃûÑéÖ¤µÄ·½·¨ÊDz»Ðе쬳ý´ËÖ®ÍâÔÚÕâ¸öÓÃc++.net±àдµÄUbitsoft.SqlEngage.Sql.dll×é¼þÖУ¬¶Ôµ÷ÓóÌÐò¼¯µÄÇ¿ÃüÃû×öÁ˼ì²é£¬³ýÁ˼ì²éÇ¿ÃüÃûÓÐЧ֮Í⣬µ÷ÓóÌÐò¼¯µÄÇ¿ÃüÃû±ØÐëºÍUbitsoft.SqlEngage.Sql.dll×é¼þµÄÇ¿ÃüÃûÒ»Ö£¬¶øUbitsoft.SqlEngage.Sql.dllÕâ¸ö×é¼þÊÇû·¨ÓÃildasm·´±àÒ룬ÔÙÓÃilasm±àÒë»ØÈ¥µÄ¡£
ËùÒÔÂé·³¾ÍÀ´ÁË£¬¶ÔÓÚĿǰÕâ¸ö°æ±¾¿ÉÒÔ¼òµ¥µÄ·´±àÒëUbitsoft.Security.dllÕâ¸ö×é¼þ£¬È»ºóÈÆ¹ýÇ¿ÃüÃûÑéÖ¤£¬¿ÉÒÔÆÆ½â£¬ÒòΪSQL Enlight´úÂëÀïÃæÃ»ÓжÔÕâ¸ö×é¼þÑé֤ǿÃüÃûµÄÓÐЧÐÔ£¬£º£©¿ÉÄÜÊÇÍü¼ÇÁË£¬ÎÒÏëUbitSoft¹«Ë¾ºÜ¿ì»áÒâʶµ½Õâµã¡£Òò´ËÕâÖÖÆÆ½â·½·¨²¢²»ºÃ£¬¶øÇÒ±¾È˲»Ï²»¶ÈƹýÇ¿ÃüÃûµÄÆÆ½â·½Ê½£¬Ê¼ÖÕ¾õµÃ²»Ë¬£¬Ò»µ©Ê¹ÓÃÁËStrongNameSignatureVerificationEx·½·¨½øÐÐÑéÖ¤µÄ»°£¬ÄÇôÕâÖÖ·½·¨¾Í²»´ÕЧÁË¡£
²»¹ýÎÊÌâÀ´ÁË£¬ÅׯúÁËÈÆ¹ýÇ¿ÃüÃûµÄ·½Ê½£¬¸ã²»¶¨Ubitsoft.SqlEngage.Sql.dll×é¼þ¾Íû·¨ÆÆ½âÁË£¬ÒòΪUbitsoft.SqlEngage.dll×é¼þÊÇÐèÒª±»·´±àÒëµÄ£¬µ«ÊÇËûÒªµ÷ÓÃUbitsoft.SqlEngage.Sql.dll×é¼þÖеÄTsqlParserÀ࣬ÔÚÕâ¸öÀàµÄ¹¹Ô캯ÊýÖлá¼ìÑéµ÷ÓóÌÐò¼¯£¬³ýÁËÇ©ÃûÑéÖ¤£¬»¹ÒªÑé֤ǿÃüÃûÊÇ·ñºÍUbitsoft.SqlEngage.Sql.dllÒ»Ö£¬Òò´ËÍêÃÀµÄ·½Ê½¾ÍÒªÐÞ¸ÄUbitsoft.SqlEngage.Sql.dllµÄÇ¿ÃüÃû£¬Ã»·¨·´±àÒ룬¾ÍÖ»ÄÜÓÃÁíÍâµÄ·½Ê½ÖØÐÂÇ©ÃûÕâ¸ö³ÌÐò¼¯ÁË£¬³¢ÊÔÁËILMerge.exe£¬sn.exe£¬signer.exe£¬snremove.exeµÈ£¬ÎÞÒ»´ÕЧ£¬ÔÒò¾ÍÊÇÕâÊÇÒ»¸ö»ìºÏ±à³ÌµÄ×é¼þ£¬ÓÐunmanaged code£¬ÓôÃÆ°¡¡£
ÓÚÊÇÎÒ´òËã·ÅÆúÐÞ¸ÄUbitsoft.SqlEngage.Sql.dll×é¼þµÄÇ¿ÃüÃûÁË£¬Ïëͨ¹ý¼ä½ÓµÄ·½Ê½¹¹Ôì³öTsqlParser¶ÔÏó£¬È»ºó¸³Öµ¸øÆÆ½âµÄ×é¼þ£¬²»¹ýÕâô×ö±È½ÏÂé·³£¬¶øÇÒÍòÒ»UbitSoft±ä̬ÆðÀ´ÔÚÿ¸ö·½·¨µ÷ÓõÄʱºò¼ì²éµ÷ÓóÌÐò¼¯£¬ÄÇôÕâ¸ö·½·¨ÓÖÐв»Í¨ÁË¡£
×îºóʵÔÚû°ì·¨ÁË£¬Ö»ÄÜÓÃ×îÍÁµÄ°ì·¨À´ÖØÐÂÇ©ÃûUbitsoft.SqlEngage.Sql.dllÕâ¸ö×é¼þÁË£¬ºÃÁË£¬³É¹¦ÁË¡£
ÆÆ½â
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
declare @dfname varchar(50)
select @dfname=a.name
from sysobjects a
inner join syscomments b on a.id=b.id
inner join sysconstraints  ......
1. Ö´ÐÐÒ»¸öSQL½Å±¾Îļþ
SQL>start file_name
SQL>@ file_name
2. ¶Ôµ±Ç°µÄÊäÈë½øÐбà¼
SQL>edit
3. ÖØÐÂÔËÐÐÉÏÒ»´ÎÔËÐеÄsqlÓï¾ä
SQL>/
4. ½«ÏÔʾµÄÄÚÈÝÊä³öµ½Ö¸¶¨Îļþ
SQL> SPOOL file_name
ÔÚÆÁÄ»ÉϵÄËùÓÐÄÚÈݶ¼°üº¬ÔÚ¸ÃÎļþÖУ¬°üÀ¨ÄãÊäÈëµÄsqlÓï¾ä¡£
5. ¹Ø±Õspool ......
±¾ÊµÀýÒ»Ì×ÈËʹÜÀíϵͳ£º¿ª·¢¹¤¾ßΪVFP9.0¡¢SQL2000¡¢EXCEL;ʹÓÃÁËAdobe PhotoshopÆ½ÃæÉè¼ÆÈí¼þ£¬²ÉÓÃÁËSPT´©Í¸¼¼Êõ£¬µ÷ÓÃÁËAPIº¯Êý£¬ÊµÏÖÁ˶Ôϵͳʱ¼äµÄͳһ¿ØÖÆ¡¢¶ÔDNSµÄ´úÂë¿ØÖÆ¡¢¶ÔÓòÃû½âÎöµÄÓ¦Ó㬵ȵÈ
ÔΣ¬ÔõôÉÏ´«£¬£¨°üº¬Ô´Âëδ±àÒëµÄ£©ÏëÒªµÄ¸øÎÒ·¢E-MAIL:zhao@tom.com ......
SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó:
Ò»."SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø"
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔÒò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµ ......