Select Pr_Maneja_Talla, Pr_Maneja_Color from Producto where Pr_Cve_Producto = '' and Es_Cve_Estado <> 'BA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ORDEN_BUSQUEDA_CLAVE_PRODUCTO' SELECT Ptc_Codigo AS Nombre FROM Producto_Talla_Color WHERE Ptc_Codigo = 'p4056p' Select Pr_Maneja_Talla, Pr_Maneja_Color from Producto where Pr_Cve_Producto = '' and Es_Cve_Estado <> 'BA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ORDEN_BUSQUEDA_CLAVE_PRODUCTO' SELECT Ptc_Codigo AS Nombre FROM Producto_Talla_Color WHERE Ptc_Codigo = 'p4056p' Select Pr_Maneja_Talla, Pr_Maneja_Color from Producto where Pr_Cve_Producto = '' and Es_Cve_Estado <> 'BA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ORDEN_BUSQUEDA_CLAVE_PRODUCTO' SELECT Ptc_Codigo AS Nombre FROM Producto_Talla_Color WHERE Ptc_Codigo = 'p4056p' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_VENTA_CLASIFICADOR_POS' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RFC' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RAZON_SOCIAL' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID EXEC SP_RPT_FTTK02_1 '0001' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK02' ORDER BY Fr_ID EXEC SP_RPT_FTTK02_2 '0001' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'FTTK02' SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID EXEC SP_RPT_VNTK01_3 '01-0000006' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID EXEC SP_RPT_FTTK01_1 '0001' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK01' ORDER BY Fr_ID EXEC SP_RPT_FTTK01_2 '0001' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'FTTK01' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID EXEC SP_RPT_VNTK01_1 '01-0000006' SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK01' ORDER BY Fr_ID EXEC SP_RPT_VNTK01_2 '01-0000006' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'VNTK01' SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK01' SELECT Cj_Formato_Ticket as Formato FROM CAja WHERE Cj_Cve_Caja = '000001' SELECT Vn_Credito AS Nombre FROM Venta_Encabezado WHERE Vn_Folio = '01-0000006' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT Clave FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = '0001' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Cl_Descripcion AS Nombre FROM CLIENTE WHERE Cl_Cve_cliente = '0000000001' *** COMMIT *** SELECT Obj.name AS Nombre, Obj.type AS Tipo, Obj.type_desc AS nTiop, Modu.definition AS Consulta FROM MPRO_TIENDA.sys.objects Obj INNER JOIN MPRO_TIENDA.sys.sql_modules Modu ON Obj.object_id = Modu.object_id WHERE (Obj.name IN (SELECT Ats_Sp FROM Afectar_Tabla_Sp WHERE At_Tabla = 'VENTA' AND Es_Cve_Estado <> 'BA') ) AND Obj.type = 'P' ORDER BY Obj.name ASC SELECT @@VERSION AS xVersion SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION_SQL_AFECTAR' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_HISTORIAL_SEGUIMIENTO' SELECT Cl_Cve_Cliente AS Nombre FROM Venta WHERE Vn_Folio = '01-0000006' SELECT Vn_Fecha AS Nombre FROM Venta WHERE Vn_Folio = '01-0000006'