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