USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[DA_GetBodyRegion] Script Date: 02/06/2018 10:49:30 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: magic -- Create date: 4/4/2009 -- Description: Get List of all body regions -- ============================================= CREATE PROCEDURE [dbo].[DA_GetBodyRegion] -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; --BodyRegionList(Retreive Body Region List from DissectibleRegion ) SELECT [Id] ,[Name] FROM [DissectibleRegion] END GO