Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.EntidadesBancarias_Sync
AS
BEGIN
SET NOCOUNT ON;
insert into EntidadesBancarias
(id_banco,nombre,cod_banco,nombre_corto)
select distinct convert(int,codigo) as id_banco,upper(replace(nombre,'"','')) as nombre,
convert(int,codigo) as cod_banco,upper(replace(nombre,'"','')) as nombre_corto
from maeent where
codigo not in (select id_banco from EntidadesBancarias)
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.EntidadesBancarias_Sync
AS
BEGIN
SET NOCOUNT ON;
insert into EntidadesBancarias
(id_banco,nombre,cod_banco,nombre_corto)
select distinct convert(int,codigo) as id_banco,upper(replace(nombre,'"','')) as nombre,
convert(int,codigo) as cod_banco,upper(replace(nombre,'"','')) as nombre_corto
from maeent where
codigo not in (select id_banco from EntidadesBancarias)
END
GO
Depends On
2Used By
No items found