Questions tagged as 'sql'

Tagged questions
0
answers

How to use INSERT INTO (Value Currency) + SELECT (String Value) SQL DB Access

I'm trying to insert some data into a Currency format column, but the data is String . I tried to convert using Convert(Dados_String, Currency) , but it did not work either. Follow the command: INSERT INTO Tabela1(Dados_C...
asked by 16.04.2015 / 17:28
1
answer

Delete only one record in the database [closed]

When you run the code below, more than one record is deleted from the database. I can not find the problem. Exclude Code exclude_client.php <?php require 'repositorio_clientes.php'; $clientes = $repositorio->getListarClientes()...
asked by 21.04.2015 / 21:45
1
answer

Doubt about 'NUMA' (non uniform memory access) in Microsoft SQL Server

Can anyone help me to understand the concept of 'NUMA' in Portuguese and their respective characteristics sff? I've found websites in English, but I still do not understand!     
asked by 27.05.2015 / 02:40
0
answers

Execute SQL command in a virtual machine

I have a form, which has the login and password fields. I want to do an update command in sql on a virtual machine of course, whoever runs the program will not have privileges to execute commands in the virtual machine. I want to update th...
asked by 26.05.2015 / 22:37
1
answer

Trigger that feeds a table with information from the other MySQL

I have a database in MySQL with the Inventory, Sales and SalesIt tables. When you perform a sales record information on the Sales and SalesItems tables, but I want to get an information from the Inventory table and register on the Ite_Venda....
asked by 31.03.2015 / 14:05
1
answer

Mysql - Triggers of derived values

I researched and found nowhere. I'm starting to study in Database and need the following help: A Class table has the following structure: Id_turma (self-incrementing) Max_children (maximum number of students) student_sum (column derive...
asked by 03.06.2015 / 05:22
0
answers

Query return does not hit

I'm trying to create a query that returns the calculated cost of certain products, and I'm curious to know why when we do joins - in this case a left join - the result that should be x becomes w . The query looks so...
asked by 24.02.2015 / 19:54
1
answer

Return last entry of each object in the database

I have two tables: monitor_carro id serial | setor_id | modelo | ano | placa monitor_evento id serial | lat | long | data | fkfuncionario_id | time | carro The monitor_evento table only has a foreign key th...
asked by 25.02.2015 / 19:24
0
answers

Splitting Duplicates in a Subreport - MSSQL / Crystal Reports

I would like to generate a PIS and COFINS tax forecast report, which is calculated based on a CFOP code of the notes issued in a given period, but would like to separate this information in "blocks" / p> I expect the result this way: +------...
asked by 24.02.2015 / 21:07
1
answer

Use comboboxes to list cities and neighborhoods

I want users to select the city and neighborhood they are in, and then the city and neighborhood they want to go to through 4 comboboxes. The data is being pulled from the database, and the 2 "I'm in:" comboboxes are working, but the "I want to...
asked by 14.04.2015 / 17:25