Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @iDConstante | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.UPDATE_CONSTANTE_FROM_TEST
@iDConstante int
AS
BEGIN
SET NOCOUNT ON;
update drglobal.dbo.gdl_constantes
set drglobal.dbo.gdl_constantes.texto_idioma_1 = T.texto_idioma_1,
drglobal.dbo.gdl_constantes.texto_idioma_2 = T.texto_idioma_2,
drglobal.dbo.gdl_constantes.texto_idioma_3 = T.texto_idioma_3,
drglobal.dbo.gdl_constantes.verificado = T.verificado,
drglobal.dbo.gdl_constantes.last_change = T.last_change
from drglobaltest.dbo.gdl_constantes T inner join drglobal.dbo.gdl_constantes P
on (T.constante = P.constante
and T.country_code = P.country_code
and T.cliente = P.cliente )
where T.id = @iDConstante
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.UPDATE_CONSTANTE_FROM_TEST
@iDConstante int
AS
BEGIN
SET NOCOUNT ON;
update drglobal.dbo.gdl_constantes
set drglobal.dbo.gdl_constantes.texto_idioma_1 = T.texto_idioma_1,
drglobal.dbo.gdl_constantes.texto_idioma_2 = T.texto_idioma_2,
drglobal.dbo.gdl_constantes.texto_idioma_3 = T.texto_idioma_3,
drglobal.dbo.gdl_constantes.verificado = T.verificado,
drglobal.dbo.gdl_constantes.last_change = T.last_change
from drglobaltest.dbo.gdl_constantes T inner join drglobal.dbo.gdl_constantes P
on (T.constante = P.constante
and T.country_code = P.country_code
and T.cliente = P.cliente )
where T.id = @iDConstante
END
GO
Depends On
No items found
Used By
No items found