代码如下:–分页存储过程示例 Alter PROCEDURE [dbo].[JH_PageDemo] pageSize int = 9000000000, pageIndex int = 1 , orderBy Nvarchar(200) = ” — 不加order By AS SET NOCOUNT ON –声明变量 DECLARE select VARCHAR(3048); DECLARE from VARCHAR(512); DECLARE RowNumber VARCHAR(256);
代码如下: create database Test on primary ( name=’Test_Data.mdf’, filename=’D:\我的资料\sql\备份\Test_Data.mdf’ ) log on ( name=’Test_Data.ldf’, filename=’D:\我的资料\sql\备份\Test_Data.ldf’ ) if object_id(‘tb’) is not null drop table tb create table tb ( Col int )
