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
-- =============================================
-- Author: <Lecolant,,Patricio>
-- Create date: <Create Date,,>
-- Description: <Obtiene marcas con cuits>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.obtener_marcas_cuit
AS
BEGIN
SET NOCOUNT ON;
SELECT top 20000 acta as num_acta,marca as nombre_marca,nbol as num_boletin,cuit,html,CLASE as clase,web,directorio
FROM marcas WHERE cuit is not null and html is null
END
GO
GO
-- =============================================
-- Author: <Lecolant,,Patricio>
-- Create date: <Create Date,,>
-- Description: <Obtiene marcas con cuits>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.obtener_marcas_cuit
AS
BEGIN
SET NOCOUNT ON;
SELECT top 20000 acta as num_acta,marca as nombre_marca,nbol as num_boletin,cuit,html,CLASE as clase,web,directorio
FROM marcas WHERE cuit is not null and html is null
END
GO
Depends On
1Used By
No items found