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Õâ¸ö×é¼þÁË£¬ºÃÁË£¬³É¹¦ÁË¡£
ÆÆ½â
Ïà¹ØÎĵµ£º
----²é¿´ËùÓнDZ¾
Create table #y (txt text)
select name, iid = identity(int,1,1) into #x from SysObjects where xtype = 'TR'
declare @i int, @max int
declare @name varchar(40)
set @i = 1
select @max = max(iid) from #x
while @i <= @max
begin
select @name = name from #x w ......
SQL> var v_str varchar2(100);
SQL> exec :v_str:=',id1,id11,id101,';
PL/SQL procedure successfully completed.
SQL> select :v_str a,replace(:v_str,',','') b
2 ,substr(:v_str,instr(:v_str,',',1,rownum)+1,
3 instr(:v_str,',',1,rownum+1)-ins ......
[ÎÊÌâ]
×î½üͻȻ·¢ÏÖSQL SERVER Éí·ÝÑéÖ¤·½Ê½ÎÞ·¨Õý³£µÇ¼ÁË£¬×ÜÊDZ¨18456´íÎ󣬶øwindows Óû§¿ÉÒÔÕý³£µÇ¼¡£
[½â¾ö·½·¨]
ÔÚÍøÉÏËÑÁËһϣ¬ÄÇЩ·½·¨¶¼²»Äܽâ¾öÎÊÌ⣬ÓÚÊÇ»ØÏë×î½üÔÚ·þÎñÆ÷ÉÏ×öµÄһЩ²Ù×÷£ºÒ»¡¢¸ü¸Ä»úÆ÷Ãû³Æ£»¶þ¡¢Õë¶ÔÈ䳿²¡¶¾½Ï¶à£¬¹Ø±ÕÁËһЩDZÔÚÍþв¶Ë¿ÚÈç135¡¢445¡¢137£º139¡£
ÓÚÊÇÏȻָ´»úÆ÷Ãû³Æ£¬ ......
ͨ³££¬ÄãÐèÒª»ñµÃµ±Ç°ÈÕÆÚºÍ¼ÆËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬ÄãµÄ³ÌÐò¿ÉÄÜÐèÒªÅжÏÒ»¸öÔµĵÚÒ»Ìì»òÕß×îºóÒ»Ìì¡£ÄãÃǴ󲿷ÖÈË´ó¸Å¶¼ÖªµÀÔõÑù°ÑÈÕÆÚ½øÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»ºó½ö½öÓ÷ָî³öÀ´µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ¼¸¸öº¯ÊýÖмÆËã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡ÔÚÕâÆªÎÄÕÂÀÎÒ½«¸æËßÄãÈçºÎʹÓÃDATEADDºÍDATEDIFFº¯ÊýÀ´¼ÆËã³öÔÚÄãµÄ³ÌÐòÖ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......