Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
3| Name | Data Type | Length | Description |
|---|---|---|---|
| @id_padron | int | 4 | |
| @estado | bit | 1 | |
| @nombre_persona | varchar | 200 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.actualizar_datos_persona_servicio_afip
@id_padron int,
@estado bit,
@nombre_persona varchar(200)
AS
BEGIN
SET NOCOUNT ON;
--select * from datos_personas where c01_cuit = '30501677643'
--select * from datos_sociedades where cuit = '30501677643'
--update padrones set afip_activo=@estado,ismodified=getdate(),nombre_persona=@nombre_persona where id_padron = @id_padron
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.actualizar_datos_persona_servicio_afip
@id_padron int,
@estado bit,
@nombre_persona varchar(200)
AS
BEGIN
SET NOCOUNT ON;
--select * from datos_personas where c01_cuit = '30501677643'
--select * from datos_sociedades where cuit = '30501677643'
--update padrones set afip_activo=@estado,ismodified=getdate(),nombre_persona=@nombre_persona where id_padron = @id_padron
END
GO
Depends On
No items found
Used By
No items found