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

Çë½ÌSQLת»»×Ö·ûÎÊÌâ - .NET¼¼Êõ / ASP.NET

SQL code:

declare @pagecount int
declare @sql varchar(500)
set @pagecount=10
set @sql='select top '+cast(@pagecount as varchar(10))+' * from book order by [ID] desc'
exec (@sql)



Ö´Ðлᱨ´í¡°ÔÚ½« varchar Öµ 'select top 10 * from book order by [ID] desc' ת»»³ÉÊý¾ÝÀàÐÍ int ʱʧ°Ü¡£¡±

ÇëÎÊÕâÀïÔõôƴ×Ö·û£¿Èç¹û±íÃûÊDZäÁ¿ÇëÎÊÔõôƴд£¿
Ë­ÓÐSQLÆ´×Ö·ûµÄ×ÊÁÏ£¿·¢ÍøÖ·£¬Ð»Ð»
¸ÕÊÔÁËÏ£¬ÉÏÃæÕýÈ·£¬µ«ÏÂÃæÕâ¶ÎÖ´ÐеÄʱºò³öÎÊÌ⣿

´´½¨´æ´¢¹ý³Ì
SQL code:

create proc book_page3
@page int,@pagecount int
as
declare @sqls varchar(500)
declare @page2 int
declare @counts int
declare @sqlc int
declare @sqll int

select @counts=count(*) from book
set @sqlc=@counts/@pagecount+1
if @page<=@sqlc and @page<>0
begin
if @page<>1
begin
set @page2=@pagecount*(@page-1)
select top (@pagecount) * from book where [ID]<(select min(ID) from (select top (@page2) ID from book order by [ID] desc)b) order by [ID] desc
end

else
begin
set @page2=@pagecount*@page
select top (@pagecount) * from book order by [ID] desc
end
end
else
begin
set @sqll='select top '+cast(@pagecou


Ïà¹ØÎÊ´ð£º

WapµÄÒ»¸ö¾ÞÍ·ÌÛµÄÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......

ÇóÖúasp.netͼƬÉÏ´« - .NET¼¼Êõ / ASP.NET

¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£

ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......

asp.netÈçºÎÌá¸ß·ÃÎÊËÙ¶È - .NET¼¼Êõ / ASP.NET

ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë  
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵ 
3Q´ó¼Ò
htmlÒ³Ãæ.

Õâ¸ö,¼ÈÈ»Ö÷Ò ......

asp.net ÏÂÔØ - .NET¼¼Êõ / ASP.NET

sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")

ÒýÓÃ
Response.Redirect( ......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ