Questions tagged as 'sql'

Tagged questions
1
answer

Know with which tables a view was created, SQL Server [closed]

I am analyzing a database and there is a view that I do not know where the information comes from, is there a sentence to know where the data is coming from?     
asked by 12.05.2017 / 08:15
0
answers

Disadvantages updating registration by plane

I'm trying to load a plan to update the promotion group. I have the following option of select, when option 4 is selected, which is a reference provider, it is necessary to create a temporary table so that the update is made to the desired table...
asked by 05.05.2017 / 21:17
1
answer

Connection to Mysql via SSL

Good morning, everyone. I am developing a program to manage a database created in Mysql. My application is in java and to connect to the database at the moment I was using the driver manager of the mysql connector in an insecure way. Now that I...
asked by 08.05.2017 / 09:33
1
answer

Assign user and permissions to SQL DB by means of Script

Performing a migration of numerous databases, we need to assign a Windows user and its permissions to each of the restored databases. Could this be done by means of a scritp? In this way you would avoid repeating the same process so many time...
asked by 29.05.2017 / 10:10
0
answers

as I pass several variables

I have this function that calculates the distance between 2 points. With a point it works fine, but I would like to do it with several at the same time, and I do not know how to pass the results of my SQL query 1 to 1. <?php function d...
asked by 11.05.2017 / 15:56
1
answer

SQL statements in Visual Studio .NET applications

With the following image I intend to explain myself in a better way. My goal is to create an App similar to Query browser. (I do not know if it will be correct to say interpreter SQL simulator). Being able to execute SQL statements V...
asked by 25.05.2017 / 22:58
2
answers

Table Pivot SQL Server

I have a query, which gives me the following results. **cedis validacion_clientes Totales** Celaya No visito a todos los clientes 17.33 Celaya Visito todos los cl...
asked by 12.05.2017 / 15:02
1
answer

Check if A CONSTRAINT UNIQUE already exists in a table? Visual Basic .NET Access

I'm in Visual Basic trying to make a program to manage a database, well I have the following SQL statement in the program to add UNIQUE to two fields of a table: "ALTER TABLE RESEARCHERS ADD CONSTRAINT RESEARCHERS UNIQUE (resEmail, resPhoneNu...
asked by 27.04.2017 / 11:59
1
answer

How to convert a string type data to int (float) and get an average?

I have a query that gives me results of type string, that data is converted to an integer type (I clarify that I can also convert it to float) and then I want it to give me the averaged result about it. I hope and you can help me. this is...
asked by 03.05.2017 / 15:29
2
answers

error when doing procedure with cursor

I try to do this CREATE PROCEDURE temporal( IN temp INT) BEGIN DECLARE maxima INT SELECT MAX(ventas) FROM vendedor INTO maxima; CREATE TABLE ven_temp AS SELECT id_vendedor FROM vendedor; WHERE ventas=maxima; COMMIT; END; mark me:...
asked by 21.04.2017 / 07:19