USE [ITSERres]
GO
/****** Object:  StoredProcedure [dbo].[AdvanceSearchSP]    Script Date: 08/04/2014 16:21:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object:  StoredProcedure [dbo].[AdvanceSearch2]    Script Date: 07/18/2014 10:37:47 ******/
 
 
ALTER PROCEDURE [dbo].[AdvanceSearchSP]
        -- Add the parameters for the stored procedure here
 
        @SearchType nvarchar(10) = null,@CustomerID bigint = null,@StringCustomerID nvarchar(50) = null,@SiteID bigint = null,@StateID bigint = null,@PrimarycustomerOnly bit = false,@RoleID int = null,@TypeID int = null,@IsManaged bit = null,@Name nvarchar(125) = null,@NameSelection nvarchar(10) = null,@Tag nvarchar(50) = null,@TagSelection nvarchar(10) =null,@ServiceTag nvarchar(100) = null,@ServiceTagSelection nvarchar(10) =null,@SerialNumber nvarchar(50) = null,@SerialNumberSelection nvarchar(10) =null,@Comment nvarchar(250) = null,@CommentSelection nvarchar(10) =null,@IP nvarchar(50) = null,@IPSelection nvarchar(10) = null,@MAC nvarchar(50) = null,@MACSelection nvarchar(10) = null
    AS
    BEGIN
 
        SET NOCOUNT ON;
if(@SearchType = 'name')
Begin 
        -- Insert statements for procedure here
    select t.Tag,r.RESOURCENAME,rs.DISPLAYSTATE as StateName,tt.Name as TypeName,sdo.NAME as sitename,accountdef.ORG_NAME as cusotmername,t.IsManaged as ismanaged,sysinfo.SERVICETAG,r.SERIALNO
  //code goes here...

我做了以下事情： –

>我映射了SP insdie我的.edmx文件.
>我右键单击.edmx文件,单击“模型浏览器”.
>在我的模型下,我点击功能导入.
>我右键单击SP,单击编辑.
然后当我点击“获取列信息”时,我收到以下消息： –

The selected stored procedure returns no columns

有人建议吗？
谢谢