![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL应用
liucfy
魂牵梦绕~
展开
-
分页存储过程
CREATE DATABASE [PagingTest] ON (NAME = NPagingTest_Data, FILENAME = NC:/Program Files/Microsoft SQL Server/MSSQL/data/PagingTest_Data.MDF , SIZE = 8, FILEGROWTH = 10%) LOG ON (NAME = NPagingTes转载 2008-07-01 18:51:00 · 424 阅读 · 0 评论 -
分页存储过程
1if exists (select * from dbo.sysobjects where id = object_id(N[dbo].[Paging_RowCount]) and OBJECTPROPERTY(id, NIsProcedure) = 1) 2drop procedure [dbo].[Paging_RowCount] 3GO 4 5SET QUOTED转载 2008-07-01 15:48:00 · 374 阅读 · 0 评论