Questions tagged as 'sql-server'

Tagged questions
0
answers

The identifier made up of several parts could not be linked

I have the following view on sql server: create view v_ConsultarReclamo as select Reclamo.rec_IDReclamo, Reclamo.rec_numero, Reclamo.rec_fechaAlta, AreaServicio.arServ_nombre, TipoReclamo.tipRec_nombre, Calle.cal_nombre, Reclamo.rec_altura, B...
asked by 18.09.2018 / 18:02
1
answer

Enable Input According to a select PHP SQL - SERVER

Cordial Greeting. I hope you can help me with the problem I have, or an idea of how to achieve what I want. I tell you what I want to do: I have a Select PHP - SQL: Contains in the database: Id, Name, Field1, Field2, Field3, Field4, Fi...
asked by 09.10.2018 / 15:53
0
answers

Exact Hours given 2 dates in Visual Basic

Dim sql As String = "SELECT a.*, CAST(DATEDIFF (minute, a.fechaEntrada ,a.fechaSalida)/ 60.0 as decimal (18,2)) %24 as horasTrabajadas from tblasistencia a WHERE a.idClave = '" & empno & "' and a.fechaEntrada BETWEEN '...
asked by 09.10.2018 / 18:03
0
answers

Add Images to Sql Server from Android Studio

I'm trying to upload an image from Android Studio to SQL Server but I do not know how to pass it This is my code: public View onCreateView(LayoutInflater inflater, @Nullable ViewGroup container, @Nullable Bundle savedInstanceState) {...
asked by 15.09.2018 / 02:39
1
answer

stored procedure within a function

I need to execute the stored procedure within the function by sending only an ID that is the primary key to update a field in the table.     
asked by 13.09.2018 / 22:41
0
answers

Delete blank space at the end of the file (.txt)

I have a code where I make a query with php and sql server, the query brings me some records, then I create a text file (.TXT) and with a cycle while(true) I write the records and when there are no records that write I give the order b...
asked by 12.09.2018 / 21:03
1
answer

Insert data from a DataGridView to SQL in c #, Visual Studio

I am making an application that records the daily information of what was done on a farm during the day. The grid shows something like that. Where I have to enter information from the data grid to the database. But the size of the rows va...
asked by 19.09.2018 / 21:41
0
answers

Event on form with onchange

I wish that with an "onchnge" event I could show a message without having to modify the value of a in a form. I was asked that when I selected X value in my a text would be displayed that gave a description about the chosen option....
asked by 10.09.2018 / 17:01
0
answers

Unable to install .NET Framework 3.5 Service Pack

I am installing the .NET Framework 3.5 Service Pack but I could not achieve I tried to install it from the executable and from the Server Manager     
asked by 08.09.2018 / 03:07
1
answer

Average for some records in sql

tag bloque sector valor fecha temperatura 01 invernadero 19.5 06-09-2018 08:00 temperatura 01 invernadero 20 06-09-2018 08:30 temperatura 02 invernadero 18 06-09-2018 13:30 temperatura 02 invernadero 2...
asked by 07.09.2018 / 17:28