
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 · 445 阅读 · 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 · 398 阅读 · 0 评论