Questions tagged as 'sql'

Tagged questions
0
answers

Error installing SQLServer 2014

Does anyone know how to solve this error? I would appreciate it.     
asked by 11.10.2018 / 00:31
0
answers

laravel 5.5 doubt when displaying object or array in view

I'm new at laravel 5.5 (just a few weeks) I have a question and it all starts with an sql query inside the InstitucionController ... public function show($id) { $caso_estudio = CasoEstudio::find($id); $institucion = Institucion::fin...
asked by 11.10.2018 / 00:15
1
answer

Invoice table in system of different types of invoices

Good I wonder how I could create the invoice table and invoice detail in a system where not only are items sold. The question is the following in a business there is a restaurant and also sell items or products then how could you structure the d...
asked by 11.10.2018 / 03:23
0
answers

Arithmetic operations in an insert into

Good morning, I am working on making a sales database BASICO (so as not to complicate me because I just want to understand the basic logic of how to handle tickets in a BD) I have the following tables create table cliente( pk_Cliente int,...
asked by 10.10.2018 / 07:24
0
answers

how to use DateChosser in a query

Good to the whole community. I have a problem, I'm doing a program with Netbeans and I use the JDateChooser but when I make a query and delete it does not delete the record but it gives me an error. Code: tblinsumos.getSelec...
asked by 19.10.2018 / 06:47
1
answer

WHERE query conditioned by search parameters

I want to make a query where I show a result by selecting a city or by selecting a month or search by id_nodo or search by city and month to show me all the nodes in that city that month, I attach an image of my form so that you can un...
asked by 28.07.2017 / 23:11
0
answers

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server: SQL Server Network Interfaces: Error Locating Server / Instance Specified [xFFFFFFFF]

I am trying to automate the Back Up of a database that runs in SQL Server 2014 Express. For this I copied a Store Procedure from the Microsoft support page, this works since I ran it from the Sql Server Management Studio and it generates with...
asked by 09.10.2018 / 22:27
0
answers

Convert Query SQL to Linq

I need to convert this query to linq. select CONVERT(date, tt.FechaHora) , k.Numero ,MAX(FechaHora) ,MIN(FechaHora) ,count(case when tt.EstadoTransaccionID=1 then TransaccionID else null end) ,count(case when tt.EstadoTransaccionID=2...
asked by 08.10.2018 / 20:18
1
answer

Update all the records in a table using a sp

You have a table with column salary , and column bonus . The salary column has numeric data, the bonus column is a numeric type but it is empty. It is possible to create a stored procedure through which you can insert data to the whole b...
asked by 03.11.2018 / 01:44
1
answer

create trigger to change a field

I have a table that I use to send an advertisement to clients, in this table I have a field called email, I need a trigger to make the change after a customer record is inserted, to verify that this field in particular that is email, if eta null...
asked by 03.11.2018 / 01:11