ÈçºÎ½â¾öhibernate¶ÔÓÚsqlserver·ÖÒ³²éѯµÄЧÂÊÎÊÌâ
´ó¼ÒºÃ£¬hibernate¶ÔÓÚsqlserverµÄ·ÖÒ³²éѯËƺõÓÐЧÂÊÉϵÄÎÊÌ⣺
Query query=session.createQuery("from User as aa ");
query.setFirstResult(0);
query.setMaxResults(15);
µ±²éѯµÚÒ»Ò³µÄʱºò£¬·¢³ösqlÓï¾ä£ºselect top 15 ...
µ±²éѯµÚ¶þÒ³µÄʱºò£¬·¢³ösqlÓï¾ä£ºselect top 30 ...
µ±²éѯµÚÈýÒ³µÄʱºò£¬·¢³ösqlÓï¾ä£ºselect top 45 ...
......£¨·Ò³Ô½¶à£¬Ã¿´Î²éѯµÄ¼Ç¼ÊýÒ²Ô½¶à£¬¶øÿ´Î²éѯµÄÊýÄ¿Ó¦¸ÃÊÇÒ»¶¨µÄ£¬¾ÍÊÇÿҳ¼Ç¼Êý15.£©
ÔÚmysqlÖУ¬¿ÉÄܻᷢ³öº¬ÓÐlimitµÄsqlÀ´ÕæÕýÒâÒåÉϵØÏÞ¶¨·ÖÒ³²éѯµÄÆðʼµã£¬µ«ÔÚsqlserverÖУ¬ÉÏÊö½á¹ûÃ÷ÏÔÊDz»ºÏÀíµÄ£¬ÎÒÊÔ×ÅÓÃhql×Ô¼ºÐ´£¬µ«ÊÇËƺõËü²»Ö§³Öselect topµÄ·½Ê½£¬Èç²éѯµÚÈýÒ³£º
select top 15 * from user as aa where id not in (select top 30 id from user as bb) -- ÕâÑù»á±¨´í£¬Ëµ15ûÓÐÓ³Éä
Õâ¸öÎÊÌâÈçºÎ½â¾ö£¿Ð»Ð»£¬Ð»Ð»~~
·ÖÒ³¿ÉÒÔдÔÚ´æ´¢¹ý³ÌÀïѽ
ÄãÓõÄÊÇSql2000µÄÊý¾Ý¿â
ÕâôЩûÎÊÌâ
Õâ¸öЧÂÊÉÏÎÊÌâºÃÏñ²¢Ã»ÓÐÄã˵µÄÄÇôÑÏÖØ..20000Ò³·ÖÒ³ÎÒÒ²ÓõÄÕâ¸ö..²¢²»»á³öÏÖÔ½·Ô½ÂýµÄÇé¿ö..Çë·ÅÐÄʹÓÃ.Èç¹ûÄãÊÇÔÚÏë×Ô¼ºÐ´µÄ»°Äã¿ÉÒÔÓÃSQL·ÖÒ³°¡..×î¶àʹÓøöhibernateµÄSQL½Ó¿ÚÂï..
д³Éjdbc ·½Ê½
ÔÚÓ¦ÓÃÖÐ hql ºÍ jdbc »ìºÏʹÓÃ
ûÓÐÎÊÌâ°¡£¬ÄãÊDz»ÊÇÓÃSessionµÄcreateSQLQuery()·½·¨°¡£¬Õâ¸ö²ÅÊÇÖ§³Ö×Ô¶¨ÒåÓï¾äµÄŶ
ÎÒÓõİüÊDZȽÏÉϲãµÄ£¬·â×°Á˺ܶà²ã£¬ÏÖÔÚÎҾ͵÷ÓõײãµÄÔʼhibernate´¦ÀísqlÁË£¬¶àл¸÷λ~~
Ôõô»áÕâÑùÄØ£¡¡£
·Ò³Ô½¶à£¬Ã¿´Î²éѯµÄ¼Ç¼ÊýÒ²Ô½¶à£¬
Õâ¾ä»°ÓÐÎÊÌâ°É¡£¡££¡
¹þ
{{---
Ïà¹ØÎÊ´ð£º
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext
Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡
Óöþ½øÖÆ´æ·ÅËãÁË
²»Ã÷°×£¬ÄÜ×Ðϸ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......