Questions tagged as 'sql'

Tagged questions
2
answers

Problems with SQL statement

I'm doing SQL queries and it does not work for me, do you know if the syntax is fine? $consulta = "SELECT * FROM TipoVehiculo INNER JOIN VehiculoFlota ON VehiculoFlota.idtipo=TipoVehiculo.idtipo INNER JOIN Empr...
asked by 01.08.2017 / 13:21
1
answer

Query about fix c #

I am running stored procedures in my project WCF C# . From one of my SP I receive something like this: CeldaId CeldaIndicadorCodigo CeldaIndicadorTipoCodigo Then with the value of Celda Id I call another SP that brings me: Ce...
asked by 25.10.2016 / 15:50
1
answer

ERROR Converting data types to SQL Server

I start by explaining my problem, my database is an inventory and as such I have products and categories, so each product belongs to a different category. I want to make a query where I can count the number of products that each category has and...
asked by 03.09.2016 / 22:44
2
answers

Relate fields in SQL

I am creating a Database in MYSQL to use it in a Java program, I put you as I have created the first two tables for the moment: create table cliente( id_cliente int, Nombre varchar(255), Apellido varchar(255), DNI varchar(20), Calle varchar(25...
asked by 07.09.2016 / 19:24
1
answer

Replace SQL - Replace special SQL characters with function

I need to replace some special characters using SQL 2008, for that to generate a function. This is the -sql- part where the replacement is made: set @raw = replace(replace(@raw,'&lt;br /&gt; * ','<br/>*'),'&amp;nbsp;','...
asked by 18.10.2016 / 01:47
1
answer

Data showing a DataGridView in C #

How to know if a DataGridView shows the same information every time you execute an SQL query? private void timer1_Tick(object sender, EventArgs e) { data.DataSource = ""; /* Cargar datos */ data.DataSource...
asked by 14.10.2016 / 22:19
1
answer

Trigger in SQL server

I wanted to do a query of triggers in SQL Server. I do not know if it will be complex but I am needing to solve the following: The LINKED CASES column I need to be a field calculated through the execution of a trigger, every time a record is...
asked by 16.06.2016 / 13:53
1
answer

Convert VARCHAR to VARBINARY (SQL)

I was creating a stored procedure in SQL Server and I missed this conversion error. "Implicit conversion from data type to varbinary is not allowed. Use the CONVERT function to run this query." The idea is to encrypt and decrypt passwords....
asked by 18.07.2016 / 01:53
2
answers

How do I sum up the total of several grades?

In my DB I did the search of a student and threw me the subjects that he / she has studied (24 subjects), qualification of each subject and the credits of each one (1 subject = 10 credits). Now, what I want is to add the credits and that they no...
asked by 17.05.2016 / 02:32
2
answers

Update several records of a column in a single SQL query

I want to reduce the number of UPDATEs that I make from my application to the table ventas of my database. This UPDATE sends a value to the record in the ordenadores column, as long as it matches the values passed to id and...
asked by 16.05.2016 / 21:13