SELECT SYSCOLUMNS.NAME FROM SYSCOLUMNS INNER JOIN SYSOBJECTS ON SYSOBJECTS.ID = SYSCOLUMNS.ID WHERE SYSOBJECTS.NAME = 'Producto' and syscolumns.name not in('Pr_Cve_Producto','Pr_Clave_Corta','Pr_Barras') ORDER BY COLID *** BEGIN TRANSACION *** SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_PREFIJO_CODIGO_RAPIDO' SELECT Accesos FROM EMPRESAS..EasyAccess WHERE Empresa = '01' AND Operador = 'CONFIG' AND Transaccion = 'CA088' AND Personalizado = 'SI' SELECT Restriccion FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA088' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_PRODUCTO' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = 'CA088' 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 = 'CONFIG' 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 EasyAccess AS Nombre FROM EMPRESAS..Menus WHERE Clave = 'CA088' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_TIPO_CAMBIO_INICIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_SOLICITAR_MONEDERO' SELECT EasyAccess, URL FROM EMPRESAS..Menus WHERE Clave = 'CA088' SELECT Name FROM EMPRESAS..sysobjects sysobjects WHERE sysobjects.Name = 'Transaccion_Uso' AND type = 'U' INSERT INTO EMPRESAS..EasyAccess ( Empresa, Operador, Transaccion, Accesos )VALUES( '01', 'CONFIG', 'CA088', 1) SELECT Accesos FROM EMPRESAS..EasyAccess WHERE Empresa = '01' AND Operador = 'CONFIG' AND Transaccion = 'CA088' Select top 25 Modulos.Clave, Modulos.Descripcion, Menus.EasyAccess, EasyAccess.Transaccion, EasyAccess.Accesos FROM EMPRESAS..EasyAccess EasyAccess INNER JOIN EMPRESAS..Operadores Operadores ON EasyAccess.Operador = Operadores.Operador INNER JOIN EMPRESAS..Permisos Permisos ON EasyAccess.Empresa = Permisos.Empresa AND EasyAccess.Transaccion = Permisos.Menu AND Operadores.Perfil = Permisos.Perfil AND Permisos.Estado = 'AC' INNER JOIN EMPRESAS..Menus Menus ON EasyAccess.Transaccion = Menus.Clave INNER JOIN EMPRESAS..Modulos Modulos ON Menus.Modulo = Modulos.Clave WHERE EasyAccess.Personalizado = 'SI' AND EasyAccess.Bloqueado = 'NO' AND EasyAccess.Operador = 'CONFIG' AND EasyAccess.Empresa = '01' ORDER BY EasyAccess.Accesos Desc SELECT IsNull(MAX(Pr_Clave_Corta), 0) as Clave FROM Producto WHERE ISNUMERIC(Pr_Clave_Corta) = 1 SELECT IsNull(MAX(Pr_Cve_Producto), 0) as Clave FROM Producto WHERE ISNUMERIC(Pr_Cve_Producto) = 1 SELECT Mn_Descripcion FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' SELECT Un_Descripcion FROM Unidad WHERE Un_Cve_Unidad = 'PZ' AND Es_Cve_Estado <> 'BA' SELECT Un_Descripcion FROM Unidad WHERE Un_Cve_Unidad = 'PZ' AND Es_Cve_Estado <> 'BA' SELECT Un_Descripcion FROM Unidad WHERE Un_Cve_Unidad = 'PZ' AND Es_Cve_Estado <> 'BA' SELECT Un_Descripcion FROM Unidad WHERE Un_Cve_Unidad = 'PZ' AND Es_Cve_Estado <> 'BA' SELECT Un_Descripcion FROM Unidad WHERE Un_Cve_Unidad = 'PZ' AND Es_Cve_Estado <> 'BA' SELECT Cm_Descripcion FROM Comprador WHERE Cm_Cve_Comprador = '0000' AND Es_Cve_Estado <> 'BA' SELECT Pv_Descripcion FROM Proveedor WHERE Pv_Cve_Proveedor = '0000000000' AND Es_Cve_Estado <> 'BA' SELECT Sf_Descripcion FROM SubFamilia WHERE Sf_Cve_SubFamilia = '0000' AND Es_Cve_Estado <> 'BA' SELECT fm_Descripcion FROM Familia WHERE fm_Cve_Familia = '0000' AND Es_Cve_Estado <> 'BA' SELECT Ln_Descripcion FROM Linea WHERE Ln_Cve_Linea = '0000' AND Es_Cve_Estado <> 'BA' SELECT Mr_Descripcion FROM Marca WHERE Mr_Cve_Marca = '0000' AND Es_Cve_Estado <> 'BA' SELECT Dp_Descripcion FROM Departamento WHERE Dp_Cve_Departamento = '0000' AND Es_Cve_Estado <> 'BA' SELECT Ct_Descripcion FROM Categoria WHERE Ct_Cve_Categoria = '0000' AND Es_Cve_Estado <> 'BA' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT * FROM IMPUESTO WHERE Es_Cve_Estado <> 'BA' ORDER BY IM_TASA DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_COMPLEMENTO_FISCAL' SELECT Mn_Descripcion FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' SELECT TOP 1 * FROM Producto_Precio SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA012' AND Restriccion = 'CA01204' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CA01204' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA012' AND Restriccion = 'CA01203' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CA01203' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA012' AND Restriccion = 'CA01202' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CA01202' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA012' AND Restriccion = 'CA01201' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CA01201' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'CA012' AND Restriccion = 'CA012' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CA012'