Questions tagged as 'sql'

Tagged questions
1
answer

PostgreSQL - regexp_replace on SELECT

I am working with PostgreSQL and I can not perform a replacement query with REGEXP_REPLACE . What I need is for the column to go from what it looks like on the left side to what it appears on the right side: ------------- ------...
asked by 10.10.2018 / 14:25
1
answer

Error converting DropDownList to Int32

I try to enter a value by means of a form and it generates this error, could you help me please this is the form <asp:Table id="Table1" runat="server" CellPadding="8" GridLines="Both" BorderColor="white" Height="419px...
asked by 30.10.2018 / 21:56
1
answer

Left join QueryBuilder Symfony 2

I can not understand how to do a LEFT JOIN using QueryBuilder of symfony2, the query I need to ask is this: SELECT * FROM extranet.version_portal v LEFT JOIN extranet.version_portal_usuario vu ON vu.version_id = v.id;     
asked by 03.10.2018 / 11:02
1
answer

How to create classes for object / relational mapping?

I am new to hibernate and jpa, I have to create 3 classes User, Client and Attribute that will be mapped to tables, the classes have the following properties: User has: id, name, surname, password, many clients, many Attributes. Clien...
asked by 07.11.2018 / 14:29
1
answer

Help with a query in Postgres that I want to move to SQL SERVER

Good morning friends, I have the following query in postgres. select distinct on (c.cod_socio) tbl.*, h.cod_oficina, h.cod_transaccion, h.num_transaccion, h.num_sec, h.fec_movimiento from sgf_det_mov_his h inner join sgf_cuenta c on c.co...
asked by 26.09.2018 / 17:37
1
answer

Add a new column to a table with data in Laravel

In Laravel we have a users migration that comes by default with the following structure public function up() { Schema::create('users', function (Blueprint $table) { $table->increments('id'); $table->st...
asked by 06.10.2018 / 21:37
1
answer

is it possible to create a document database in MySQL?

Inside MySQL 5.7 onwards until version 8; we are already able to use attributes for data of type JSON Like this: CREATE TABLE profile( id BIGINT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) UNIQUE NOT NULL, attributes JSON NOT...
asked by 23.09.2018 / 22:12
1
answer

ORACLE SQL STATEMENT IGNORED missing parentheses right [closed]

I can not find any missing parentheses in the line set project.activity.full_in = TO_NUMBER, I have reviewed it 20 times and the parentheses close well, I have 2 errors: ORA 00907 missing parentheses right and in the previous line to that it say...
asked by 04.10.2018 / 22:33
1
answer

Validate if there is a record in a DB table and store in a variable

I am making a query to validate if there is a record in the database, for this I used the following I declare variable decimal serie= 10002;//este valor corresponde a un ejemplo, la variable puede tomar cualquier valor I make the query...
asked by 20.09.2018 / 15:53
1
answer

Take value of a field from an identifier of a table

I have the following instructions with which I intend to obtain a value of a field from an identifier of a table. idFac = Convert.ToDecimal(Request.QueryString["id"]);//Capturo el Id del registro sql.Append("SELECT codigo from factu...
asked by 19.09.2018 / 18:51