Best answeres tagged with sql-server-2014

1

answer

How to call the value of a jComboBox?

I do the following query to add elements to the comboBox: cmbCargo.setModel(obj.LlenarCombobox("costo", "SELECT * FROM tipoServicio")); (The first value is the field that is shown in the query) Using this method public...

asked by 31.08.2017 / 02:59

2

answers

Insert multiple dates for the same id - SQL Server 2014

I need to enter a full month for each "ID" field in order to verify if a hotel room is available on that date. It would be something like this: And so on for each of the 500 rooms of a hotel. I'm using SQLServer Express 2014.

asked by 21.06.2017 / 01:01

1

answer

Problems with sqlsrv_errors in php

I am using PHP 5.6 on IIS 10 with SQL Server 2014, and I have the following function to make inserts, updates and deletes to the database: <?php public function ejecutarSQL($sql,$parametrosSQLServer=array()){ $bandera=false; $msg=""...

asked by 07.03.2017 / 21:25

0

answers

Get the maximum value of a DATALENGTH from the fields in a record

asked by 04.11.2018 / 00:55

1

answer

Import data from csv file

I have a csv file which has this data that takes them out of a single field. As you will see, it is not only data from a single field. In the table where I want to insert this data has the following structure. The information I...

asked by 15.10.2018 / 16:56

0

answers

Query does not bring me the expected data

I have a selection query SELECT which when I apply a filter with WHERE no longer brings me anything but without the filter if it brings me all the data. SELECT PC.ProductoCatalogoId, P.Nombre, PC.PrecioVenta, E.Nombre, O.NombreOp...

asked by 02.10.2018 / 10:13

1

answer

SQLSERVER database

Good day for all, I need to make an insert in two tables at once, these tables are related to a cambo id in table one and is autoincrementable and in table two is the same cambo (idtabla1) is the foreign, my question is how do I keep the autoinc...

asked by 25.09.2018 / 01:01

0

answers

Error converting data type nvarchar to date

Good evening I have a problem registering a form of a dating system in which marks the error of the title, I think the solution would be to convert the following code. Private Sub BtnRegistrar_Click(sender As Object, e As EventArgs) Handles Bt...

asked by 21.08.2018 / 06:17

0

answers

my Android application does not connect to my SQL Server

I am making an application for User Logging, when running the emulator I can register users, check the users' stock in my Database , but when I run the application on my phone, I do not know connect to my Database . This is my connection co...

asked by 18.08.2018 / 18:06

0

answers

Get a particular date for each SQL ID

I am trying to get the next available date from a calculation that I show acontinuacion. That's the query I'm using but it does not work. SELECT DateID = ROW_NUMBER() over (order by B.Date_Key) ,C.FundDate FROM DIM_DATE B LEFT JOIN DIM_St...

asked by 25.06.2018 / 19:12

Questions tagged as 'sql-server-2014'