USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[GetAllModuleStatusWithSlug] Script Date: 02/06/2018 10:49:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: -- Description: -- ============================================= CREATE PROCEDURE [dbo].[GetAllModuleStatusWithSlug] -- Add the parameters for the stored procedure here AS BEGIN IF 1=0 BEGIN SET FMTONLY OFF END -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT ResourceModule.Id,ResourceModule.Title AS Name, ResourceModule.Slug FROM ResourceModule END GO