Mine

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO



ALTER PROCEDURE [dbo].[GetPortal]



	@PortalId  int



AS

SELECT *

FROM dbo.vw_Portals

WHERE PortalId = @PortalId