--利用存储过程执行创建一张虚拟表,并向表中添加数据
--下例是将一张角色表的数据copy到虚拟表中,并返回数据
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME='proc_RoleInfo_Pageing')
DROP PROCEDURE proc_RoleInfo_Pageing
GO
CREATE PROCEDURE proc_RoleInfo_Pageing
AS
DECLARE @table TABLE(Id INT IDENTITY(1,1),UserName VARCHAR(20),RoleDesc VARCHAR(50))
INSERT INTO @table SELECT RoleName,RoleDesc FROM RoleInfo
SELECT * FROM @table
GO
--调用存储过程
EXEC proc_RoleInfo_Pageing