IF OBJECT_ID( 'sp_OES_DMSAimSMAvatar_Select', 'P' ) IS NOT NULL
    DROP PROCEDURE dbo.sp_OES_DMSAimSMAvatar_Select;
GO
CREATE PROCEDURE [dbo].[sp_OES_DMSAimSMAvatar_Select]
    -- Add the parameters for the stored procedure here
    @UserName NVARCHAR(50)
AS
BEGIN
    SELECT * FROM dbo.DMSAimSMAvatar WHERE UserName = @UserName
END

GO