# "ListAllProjects" Stored Procedure

Description:

This stored procedure returns a list of all project information from the Projects table. There are no input parameters.

Definition:

    	CREATE  PROCEDURE TT_ListAllProjects

    	AS

    		SELECT ProjectID,
    			Name as ProjectName,
    			Description,
    			ManagerUserID,
    			EstCompletionDate,
    			EstDuration
    		FROM TT_Projects

Database Tables Used:

The primary key in the Projects table is the ProjectID identity field.