If I have a query of the type:
SELECT a, b FROM c WHERE a = 5 and b LIKE '%foo%'
And I have another:
SELECT a, b FROM c WHERE b LIKE '%foo%' and a = 5
I have executed both and both have the same execution time, but as for the consumpti...
I have the following table in a PostgreSQL database:
CREATE TABLE combinaciones
(
id serial NOT NULL,
valor character varying NOT NULL,
CONSTRAINT id_pk PRIMARY KEY (id)
) WITH (OIDS=FALSE);
ALTER TABLE combinaciones OWNER TO post...
Good people I have the following problem: I have a dropdownList that depending on its value brings me by ajax a different form with its respective button, until there works well.
<div id="contformularios1">
</di...
Good morning,
I am working as Windows Forms and user controls within C #, which I am working with an application that acts as a clock watch.
This first screen acts, like the main screen. Which all users have access to now.
Inside...
I have two tables jerarquia and permisos , where hierarchy has an ID, a ID_PADRE (pointing to the same table to a parent node) and a DESCRIPTION of the node itself. The permissions table has an ID_OPERATOR (id of the user that is lo...
If I have two tables that have a column called direccion , and I want to take only one of them as I do?
Client table: ID, address, level, mail, password, name
Company table: EID, address, name
What I want to do is:
SELEC...
Good morning to all of you, today I am trying to round a value of FLOAT to two decimals but doing so by consulting SQL SERVER shown below, some values rounded me correctly and others not, example: 19.1 I rounded to 19.10 already with t...
I have problems with the following query:
INSERT INTO 'pasajeros' ( 'nombre','apellidos','email','password','telefono')
VALUES ('Alexandra','Gonzalez','[email protected]','1234567!','04242344556' )
WHERE NOT EXISTS ( SELECT * FROM 'transportista...
I need to delete all the records of a SQLServer table without indicating which one I want to delete, I want them to be all and this code deletes data in specific
delete from tbl_usuarios where nombre='Abi';