sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿
ÈçÌâ: sqlserver 2005 Á½Ç§ÍòÌõÊý¾ÝÐÔÄÜÔõôÑù£¿
µÃ¿´ÄãµÄÊý¾Ý½á¹¹À´,Èç¹û²éѯʱȫÊÇLIKE Ö®Àà,ÄǾÍ.. ×îºÃÓÅ»¯ ²»Ëãʲô ºÜÕý³££¬²éѯµÄʱºò¶àÓÅ»¯£¬ÐÔÄÜ»¹ÊÇºÜºÃµÄ sqlserver 2005 Á½Ç§ÍòÌõÊý¾Ý ÖÆ¶¨ºÏÀíµÄ¹æ»®Ã»ÎÊÌ⣡ û³¬TB¼¶±ð¾Í²»Ëã´ó SQL 2005ÊÇÖ§³Öº£Á¿Êý¾ÝµÄ Ó¦¸ÃûʲôÎÊÌâ¡£ Õë¶Ô²»Í¬²éѯ·½Ê½½¨¶à¸öË÷Òý£¬²éѯµÄʱºòÑ¡ÔñÏàÓ¦Ë÷Òý¡£¡£ Ò»ÒÚ¶¼Ã»ÓÐʲôÎÊÌâµÄ¡£¡£·ÅÐÄ°É ÄÇÎÒÒªÒ»´Î²é³öÀ´Ò»°ÙÍòÄØ£¿ Ŀǰ¼ûµ½¹ý5000ÍòµÄ£¬ÓõϹ¿ÉÒÔ£¡ lz¿ÉÒԲο¼£¡ÒýÓà Ŀǰ¼ûµ½¹ý5000ÍòµÄ£¬ÓõϹ¿ÉÒÔ£¡ lz¿ÉÒԲο¼£¡ lzÊÇʲô lz¾ÍÊÇÄã ÎÒÃÇÓõÄSQL SERVER£¬Ã¿¸ö¿âÀï¶¼Óкü¸ÕűíÊÇǧÍòÊýÁ¿¼¶ÁË£¬¹ØÁª²éѯʲôµÄ£¬Ö»ÒªÄãµÄSQLÓÅ»¯µÄºÃ£¬Ð§Âʺܲ»´íµÄ¡£ ½¨Á¢SQLÀïÃæµÄË÷Òý£¬ÓÅ»¯Êý¾Ý¿â£¬Ã»ÓÐÎÊÌâµÄ¡£ Mark ¿´±íµÄ½á¹¹ºÍ²éѯЧÂÊÖ´ÐÐÁË¡£ ûÎÊÌâµÄ ½¨Á¢ºÏÀíµÄË÷Òý Ë÷ÒýÂ¿Ï¶¨ÊÇÒª½¨Á¢µÄ°¡~ ÎÒÕâ±ßµÄÊý¾ÝÊÇ1400W£¬ÎÊÌâ²»´óÒýÓà ÄÇÎÒÒªÒ»´Î²é³öÀ´Ò»°ÙÍòÄØ£¿ Ò»´ÎÐÔ²é³ö100ÍòÊý¾Ý?ÓÃÀ´×öʲô£¿ÒýÓà ÒýÓà 10 Â¥ zhangyy130 µÄ»Ø¸´: ÄÇÎÒÒªÒ»´Î²é³öÀ´Ò»°ÙÍòÄØ£¿ Ò»´ÎÐÔ²é³ö100ÍòÊý¾Ý?ÓÃÀ´×öʲô£¿ ±¨±í»ã×Ü
Ïà¹ØÎÊ´ð£º
ÔÚSqlServerÖÐÈçºÎ²é¿´ÀúÊ·ÉÏÖ´ÐеĴ洢¹ý³ÌµÄÐÅÏ¢ÄØ£¬È磺´«Èë²ÎÊý£¬Ö´ÐÐʱ¼äµÈµÈ¡£Èç¹û²»Äܲ鿴ÀúÊ·¼Ç¼£¬ÊÇ·ñ¿ÉÒÔ×Ô¼ºÐ´´¥·¢Æ÷Ö®ÀàµÄ£¬È˹¤¿ØÖÆÄØ£¬ÔÚOracleÀïÃæÓж¯Ì¬ÊÓͼ¿ÉÒÔËæÊ±²é¿´ÀúÊ·Ö´ÐеÄsqlÓï¾ä£¬SqlSer ......
Çë½Ì¸÷λ£º ÔÚ³¬ÊеÄÊÕÒøÏµÍ³ÖУ¬Èç¹ûÓÐ20¶à¸ö¿Í»§¶Ë£¬ÓпÉÄÜͬʱ¶Ôij×Ö¶ÎÊý¾Ý½øÐÐÐ޸쬻ò½øÐÐɾ³ý£¬¾ÍÓпÉÄܾͻáÔì³ÉijЩ¿Í»§¶Ë³öÏÖ´íÎó£¬Ó¦¸ÃÈçºÎÈ¥±ÜÃâÄØ£¿ÄÜ·ñÌṩ¾ßÌåÊÂÀý£¬Ð»Ð» Ôõô»áͬʱÐÞ¸ÄÄØ£¿
......
PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (×ªÔØ) PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ) 2007-11-02 22:27 ´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS) »»³ÉÁË ......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£ ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
create trigger [trgDeleteEuser] on [dbo].[E_UserInfo] for delete as delete Job_Info from Job_Info j join Deleted d on j.user_name=d.user_name delete job_evaluation from job_evaluation ......