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

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Õâ¸ö×é¼þÁË£¬ºÃÁË£¬³É¹¦ÁË¡£
ÆÆ½â


Ïà¹ØÎĵµ£º

SQL³£Óú¯ÊýÖ®Èý REPLICATE () £¿


°´Ö¸¶¨´ÎÊýÖØ¸´×Ö·û±í´ïʽ¡£
Óï·¨
REPLICATE ( character_expression, integer_expression)
²ÎÊý
character_expression
×Ö·ûÊý¾ÝÐ͵Ä×ÖĸÊý×Ö±í´ïʽ£¬»òÕß¿ÉÒÔÒþʽת»»Îª nvarchar »ò ntext µÄÆäËûÊý¾ÝÀàÐ͵Ä×ÖĸÊý×Ö±í´ïʽ¡£
integer_expression
¿ÉÒÔÒþʽת»»Îª int µÄ±í´ïʽ¡£Èç¹û integer_expression Ϊ ......

SQL ServerÖйØÓÚµÄcheckpointʹÓÃ˵Ã÷

ÔÚSQL ServerÖÐÓÐÒ»¸ö·Ç³£ÖØÒªµÄÃüÁî¾ÍÊÇCheckPoint£¬ËüÖ÷Òª×÷ÓÃÊǰѻº´æÖеÄÊý¾ÝдÈëmdfÎļþÖС£
ÆäʵÔÚÎÒÃǽøÐÐinsert, update, deleteʱ£¬Êý¾Ý²¢Ã»ÓÐÖ±½ÓдÈëÊý¾Ý¿â¶ÔÓ¦µÄmdfÎļþÖУ¬¶øÊÇдÈëÁË»º´æÀÕâÓеãÏñµç¿£¬ÒòΪ¹ýÓÚÆµ·±µÄдÈë»áʹ´ÅÅ̵ÄÊÙÃü´ó´ó¼õС¡£
 
´ÓÉÏͼ¿ÉÒÔÖ±¹ÛµÄ¿´³ö¡£Ö»Óе±·¢Éúcheckpoint ......

SQL×¢ÈëÒ»ÈÕͨ£¨Ï£©|Findnet.com.cn


Îå¡¢ÉÏ´«ASPľÂí
        ËùνASPľÂí£¬¾ÍÊÇÒ»¶ÎÓÐÌØÊ⹦ÄܵÄASP´úÂ룬²¢·ÅÈëWEBÐéÄâĿ¼µÄScriptsÏ£¬Ô¶³Ì¿Í»§Í¨¹ýIE¾Í¿ÉÖ´ÐÐËü£¬½ø¶øµÃµ½ÏµÍ³µÄUSERȨÏÞ£¬ÊµÏÖ¶ÔϵͳµÄ³õ²½¿ØÖÆ¡£ÉÏ´«ASPľÂíÒ»°ãÓÐÁ½ÖֱȽÏÓÐЧµÄ·½·¨£º
1¡¢ÀûÓÃWEBµÄÔ¶³Ì¹ÜÀí¹¦ÄÜ
      ......

SQLÓÅ»¯34Ìõ

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......

Àμǣ¡SQL ServerÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ(SQLÊÕ²Ø)

Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Äã¶¼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâÆªÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾­Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ