asp.net²éѯSqlServerÖÐtextÀàÐÍÊý¾Ý¶ªÊ§
asp.net²éѯSqlServer2005ÖÐtextÀàÐÍÊý¾Ý³£³£¶ªÊ§£¬Ìí¼ÓÊý¾Ýµ½textÀàÐÍÖп´Ò³ÃæÉÏ¿ÉÒÔ£¬ÓиöÒ»Á½Ì죬¾Í¿ÉÄÜ»á³öÏÖtext Êý¾Ý´æµÄÊý¾ÝȱÉÙÒ»²¿·Ö£¬ÎªÊ²Ã´°¡£¡Çë´ó¼Ò°ï°ïæ°¡£¡
Óöþ½øÖÆ´æ·ÅËãÁË ²»Ã÷°×£¬ÄÜ×Ðϸ˵˵Â ¶¥ ´æÊý¾ÝµÄʱºò ÊDz»ÊÇÓõIJÎÊý£¬textÀàÐͲ»ÒªÖ¸¶¨´óС¡£ UP ²»Îȶ¨¾Í²»Ì«ºÃ½â¾öÁË ÉÙÒ»²¿·Ö£¬ÊDz»ÊÇÄã´«²ÎµÄʱºòÖ¸¶¨Á˳¤¶È£¬¶øÄãµÄÄÚÈݳ¬³öÁ˳¤¶ÈÄØ Ã»ÓжԴ洢µÄÊý¾ÝŪ´óС£¬ÎÒÏÖÔÚÏëµÄÊDz»ÊÇÒòΪÊý¾Ý¿âÖеÄÊý¾Ý´æµÄ¶àÁË£¬Êý¾Ý¿â»á×Ô¶¯½ØÈ¡£¬¾ÍÏñÎÒ´Ó°Ù¶ÈÉÏ¿´µÄ£¬ÊDz»ÊÇÓ¦¸ÃtextÀàÐ͵ÄÊý¾Ý³¬¹ý¶àÉÙk£¬Êý¾Ý¿â¾Í×Ô¶¯¸ø½ØÈ¡ÁË£¬µ÷µ½Êʵ±´óС·¶Î§£¬²Å»á³öÏÖÎÒÏÖÔÚµÄÎÊÌâ°¡£¡ »¹ÒªËµµÄÒ»µã¾ÍÊÇ£¬ÎÒͬÑùµÄ³ÌÐò¶¼ÊǸøÎÄÕ±íµÄcontent×ֶζ¨ÒåµÄtextµÄÀàÐÍ£¬ÄǸöÍøÕ¾ÉϾÍûÓÐʲôÎÊÌ⣬ÄǸöÍøÕ¾¾ÍÊDZÈÎÒÏÖÔÚµÄÍøÕ¾µÄÊý¾ÝÁ¿´óºÃ¶à£¬²¢ÇÒ£¬Ã¿Ìì·ÃÎÊÁ¿Ò²ÊÇͬÑùÒª´ó¡£ÎÒÏÖÔÚ¾ÍÊǾõµÃ¿ÉÄÜtextÀàÐÍ£¬ÎÒÒªÉèÖÃʲô¶«Î÷£¬Ö»ÊDz»ÖªµÀÉèÖÃʲô£¿Çë¸ßÊÖÖ¸µã°¡£¡¼°¼°¼°¼°¼°¼°¼°¼°¼°¼°¼° ¼° Õâ¸öÒª×Ðϸ²é¿´ text ÀàÐ͵Ĵ洢·½Ê½ºÍ´óСÏÞÖÆ,È»ºóºÍÄã´æ·ÅµÄÎı¾±È¶Ô,±ÈÈçÄãµÄÎı¾Öг¤¶È¶àÉÙ,ÊÇ·ñ°üº¬Òì³£×Ö·û,×îºó²Å¿É³õ²½µÃ³ö½áÂÛ,ͬʱµÃÓÃÆäËû·½·¨×¥¸öʵÀýÑо¿ **ϵͳÉè¼ÆÕß,¸ßÊÖµÄÀÖÔ°,»¶ÓÀ´QQȺ: 102271374 Ò¼µÀÉè¼Æ** ¼ÌÐø¶¥Ò»Ï sql 2005 ½«³¬¹ý 8,000 ¸ö×Ö·ûµÄ×Ö·û´®ºÍ´óÓÚ 8,000 ×ֽڵĶþ½øÖÆÊý¾Ý´æ´¢ÎªÃûΪ text ºÍ image µÄÌØÊâÊý¾ÝÀàÐÍ¡£ºÜÓпÉÄܵ±Ç°ÊäÈë×Ö·û´®³¤¶È´óÓÚÁËÕâÒªÇó¡£ ¸öÈ˽¨Ò飬Èç¹û²»ÊÇ´æ´¢Êý¾Ý¿éµÄ»°£¬¿ÉÒÔÊÔÊÔvarchar,»òÕßnvarchar ¶¥ÒýÓà ÉÙÒ»²¿·Ö£¬ÊDz»ÊÇÄã´«²ÎµÄʱº
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product) ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
СµÜÊǽñÄê¸Õ±ÏҵѧÉúÕÒÁ˺ܳ¤Ê±¼ä¹¤×÷ÁË,×ÜÊÇʧ°Ü£¬Ò»Ð©¹«Ë¾¶¼ÒªÓй¤×÷¾ÑéµÄ£¬¶¼±ÀÀ£ÁË£¬ËùÒÔÏëÇë¸÷λ´ó¸ç°ï¸öæ ½ñÌìÎÒÈ¥ÃæÊÔÁËÒ»¼Ò¹«Ë¾£¬ËûÊÇÏë×öÒ»¸ö¡°Ò½ÁƵÄÍøÕ¾¡±Ï൱ÓÚÊÇÍƹã×Ô¼ºµÄÒ½ÁÆ·½·¨°É£¬Ëû½ÐÎ ......
CREATE PROCEDURE [selectvipcompany] @username varchar(50), @companyname varchar(50), @endtime varchar(1) AS declare @sql varchar(1000) set @sql='' ......
ÎÒ´´½¨ÁËÒ»¸öÎïÆ·ä¯ÀÀÒ³Ã棺bookview.aspx£¬ÆäÖÐÔÚÒ³ÃæµÄ×ó²àÁгöÎïÆ·µÄ·ÖÀࣺ·ÖÀà1£¬Á¬½Óµ½Ò³Ãæbookview.aspx£¿id=1£¬ÆäËûÒÀ´ÎÀàÍÆ£¬µ±Ò³ÃæµÚÒ»´Î¼ÓÔصÄʱºòÉèÖÃidµÄĬÈÏֵΪ1£¬ÔËÐгÌÐò·¢ÏÖÒ³ÃæÒ»Ö±³öÓÚÖØÐÂ¼Ó ......