 
 GO
 
-/****** Object:  StoredProcedure [dbo].[SP_USERS_LISTAR]    Script Date: 11/11/2016 22:58:54 ******/
+/****** Object:  StoredProcedure [dbo].[SP_USERS_LISTAR]    Script Date: 14/11/2016 21:52:32 ******/
 
 SET ANSI_NULLS ON
 


GO

/****** Object:  StoredProcedure [dbo].[SP_USERS_BYID]    Script Date: 11/11/2016 22:58:54 ******/

SET ANSI_NULLS ON



GO

/****** Object:  StoredProcedure [dbo].[SP_PBACKLOG_UPDATE]    Script Date: 14/11/2016 21:52:32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO



CREATE PROC [dbo].[SP_PBACKLOG_UPDATE]

@IDProjeto int,

@Historia nvarchar(50),

@Importancia nvarchar(50),

@Estimativa Datetime,

@Aceito nvarchar(50),

@ID INT

AS

UPDATE Product_Backlog

   SET [ID_Projeto] = @IDProjeto,

	   [Historia] = @Historia,

	   [Estimativa_Inicio] = @Estimativa,

	   [Importancia] = @Importancia,

	   [Aceito] = @Aceito

 WHERE ID_PBacklog=@ID



/****** DETALHES     ******/





GO

/****** Object:  StoredProcedure [dbo].[SP_PROJETO_DELETE]    Script Date: 14/11/2016 21:52:32 ******/

SET ANSI_NULLS ON

