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

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»ÊÇÄã´«²ÎµÄʱº


Ïà¹ØÎÊ´ð£º

asp.net·ÖÒ³ÎÊÌâ

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 ......

ASP.net¸÷λ´ó¸ç°ïæ

СµÜÊǽñÄê¸Õ±ÏҵѧÉúÕÒÁ˺ܳ¤Ê±¼ä¹¤×÷ÁË,×ÜÊÇʧ°Ü£¬Ò»Ð©¹«Ë¾¶¼ÒªÓй¤×÷¾­ÑéµÄ£¬¶¼±ÀÀ£ÁË£¬ËùÒÔÏëÇë¸÷λ´ó¸ç°ï¸öæ

½ñÌìÎÒÈ¥ÃæÊÔÁËÒ»¼Ò¹«Ë¾£¬ËûÊÇÏë×öÒ»¸ö¡°Ò½ÁƵÄÍøÕ¾¡±Ï൱ÓÚÊÇÍƹã×Ô¼ºµÄÒ½ÁÆ·½·¨°É£¬Ëû½ÐÎ ......

sql´æ´¢¹ý³Ìʱ¼äÏà¼õ - .NET¼¼Êõ / ASP.NET

CREATE PROCEDURE [selectvipcompany] 
@username varchar(50), 
@companyname varchar(50), 
@endtime varchar(1) 
AS 
declare @sql varchar(1000) 
set @sql=''  ......

asp.net»Øµ÷ÎÊÌâ - .NET¼¼Êõ / ASP.NET

ÎÒ´´½¨ÁËÒ»¸öÎïÆ·ä¯ÀÀÒ³Ã棺bookview.aspx£¬ÆäÖÐÔÚÒ³ÃæµÄ×ó²àÁгöÎïÆ·µÄ·ÖÀࣺ·ÖÀà1£¬Á¬½Óµ½Ò³Ãæbookview.aspx£¿id=1£¬ÆäËûÒÀ´ÎÀàÍÆ£¬µ±Ò³ÃæµÚÒ»´Î¼ÓÔصÄʱºòÉèÖÃidµÄĬÈÏֵΪ1£¬ÔËÐгÌÐò·¢ÏÖÒ³ÃæÒ»Ö±³öÓÚÖØÐÂ¼Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ