Questions tagged as 'sql'

Tagged questions
2
answers

Too much response time in a Sql Server procedure

I have the following code in a procedure: DECLARE @Temp_Entidades TABLE(Id int); with Report(Id) as ( --primer select select distinct e.Id from EntidadesPersonas as ep right join Entidades as e on ep.EntidadId=e.Id where...
asked by 21.10.2016 / 19:06
1
answer

Connect Cloud SQL from App Engine

I've been trying to connect SQL SQL from app engine with java for a few days. but when making the connection I get the error:    No suitable driver found for jdbc: mysql: //104.155.83.62/BD-myApp? user = root; password = root I leave you...
asked by 28.11.2016 / 08:47
1
answer

Errors when installing SQL Server 2012 (sqlwriter.msi) which then tells me that the user does not exist

During the installation, there is no error in the wizard's requirement checks and everything is in order. I followed the instructions of the most popular video of installation of the program on YouTube. At the time of installation is where er...
asked by 04.12.2016 / 22:20
1
answer

Problem when generating one in SQL server to show them in an xtraReport?

When generating the query for the dates in SQL the result is correct, but when I put it in separate queries, when I want to see it in XtraReport only shows me the first one, my question is how could I solve this problem ? either fr...
asked by 15.10.2016 / 15:09
3
answers

update data from one table from another in SQL

I would like to know if it is possible, and how it is done, to update data from one table by others from another. For example: Table 1: id_tabla1 | Nombre | Descripcion Table 2: id_tabla2 | Nombre | Descripcion The difference be...
asked by 03.11.2016 / 01:56
3
answers

Do not send the sql query from eclipse

I have this code that is the form of my window to enter a server to a database that is created from wamp . The problem is that he does not send me the query, the connection seems to be fine I leave the code here package Ventanas;...
asked by 26.10.2016 / 05:40
1
answer

perform an update type trigger

I have the following query: Realize a trigger of type update in the table "x" and verify if the new data of the name and appelled already exist, if they do not change, otherwise modify the information. create trigger ActualizarInfo on tabla1 f...
asked by 10.08.2016 / 20:51
2
answers

How do I do the following copy a column of a table to another table

I explain in database how I do if in the database users.dbo.Users_Master I have 18,000 accounts or more and made the mistake of adding 2,000,000 points in the points column but before I had a backup which shows that the maximum of any user was 6...
asked by 14.08.2016 / 21:54
2
answers

create an sp that receives the necessary parameters to enter a new element in "x" table, but that the name of the new element does not duplicate

my question is how to compare in the if, the variable that I created called @name with the attribute of the table called Name?     
asked by 19.07.2016 / 17:52
2
answers

Consult a segmented field

I have two tables which one is created from the data of the other fields: CREATE TABLE1( CAMPO1 VARCHAR2(15), CAMPO2 VARCHAR2(15), CAMPO3 VARCHAR2(5), CAMPO4 VARCHAR(20)); CREATE TABLE2( CAMPO1 VARCHAR(20), CAMPO2 VARCHAR(30)); I want to i...
asked by 22.11.2016 / 16:30