sql临时表的创建及赋值
DECLARE @t TABLE
(
[RoleID] [INT] ,
[RoleName] [NVARCHAR](50) ,
[RoleLevel] [INT] ,
)
INSERT INTO @t
(
[RoleID] ,
[RoleName],
[RoleLevel] ,
)
SELECT [RoleID] ,
[RoleName],
[RoleLevel] ,
FROM dbo.HR_Role
SELECT * FROM @t