解决办法:创建存储过程 CREATE PROCEDURE GL_SP_GetAllTrade AS SET NOCOUNT ON CREATE TABLE #Trade(iTrade_ID int ,cTrade_Name nvarchar(60),iOrder int IDENTITY(1,1)) INSERT INTO #Trade(iTrade_ID,cTrade_Name) SELECT EnumIndex,EnumName from v_AA_enum where EnumType='Admin.Trade' AND EnumIndex=36 order ...