USE [Mantenedores]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'SP_UsuarioDados_Id') AND TYPE IN ( N'P', N'PC' ))
BEGIN
    DROP PROCEDURE [dbo].[SP_UsuarioDados_Id]
END
GO
/* ----------------------------------------------------------------------------------
NAME: SP_UsuarioDados_Id
OBJECT: STORED PROCEDURE
CREATED: 21/07/2017
AUTHOR: Renato Carvalho (S2IT)
PROJECT: Mantenedores
OBJECTIVE: Selecionar os Usuários dados pelo Id.
---------------------------------------------------------------------------------- */
CREATE PROCEDURE [dbo].[SP_UsuarioDados_Id]
(
    @Id UNIQUEIDENTIFIER
)
AS
BEGIN
    SELECT * FROM UsuarioDados WHERE UsuarioDadosId = @Id
END
GO