if OBJECT_ID('sp_lookupMediaTypeData') is not null
 drop procedure sp_lookupMediaTypeData
GO
CREATE procedure sp_lookupMediaTypeData
 @bagtype int =1 
AS
BEGIN
  select dataid MediaData_TypeId, sort MediaData_Id,serialno MediaData_SerialNo  from ktvmodule_classdata order by dataid asc,sort asc
END
GO 
if OBJECT_ID('spa_lookupMediaTypeData') is not null
 drop procedure spa_lookupMediaTypeData
GO
create procedure spa_lookupMediaTypeData
 @bagtype int =1 
As
BEGIN
    declare @retcode int
     exec @retcode=sp_lookupMediaTypeData 
     return @retcode
END