spWorkflows

    create procedure [dbo].[spWorkflows]
    (
        @ContentTypesID int = null
    )
        AS
            select    [ID],
                    [Name],
                    [Description],
                    [IsDefault],
                    [ContentTypesID]
            from dbo.Workflow
            where @ContentTypesID is null or 
            (@ContentTypesID is not null and [ContentTypesID]=@ContentTypesID)
        return