Questions tagged as 'sql-server'

Tagged questions
1
answer

Select record with the highest value in a field

I am making a query in SQLServer where I require the record of days worked of x number of employees. On the days when they are at Rest, they can work obtaining the additional day. The query I have generates the following id cliente pues...
asked by 13.06.2016 / 20:00
1
answer

How to upload multiple files to a record of a SQL server table from VB.NET and ASP.NET

Currently I have an ASP application where I make certain information records, to this record I attach a PDF file, for that I store the file in a folder within my project and save the path in my bd. My question is, in the case that I want to a...
asked by 12.09.2016 / 18:00
2
answers

PHP does not show errors in the connection even if it is incorrect

I have the following code that makes the connection of php and sql server but although I put the data of the connection wrong it does not show me any error: <?php session_start(); if (isset($_SESSION['usuario'])) { header('location: co...
asked by 06.05.2016 / 17:14
0
answers

How can I program a textbox so that when I double-click it, I fill it in with BD information?

Recently I got involved in a project and I have a doubt, if it is possible (and if it is how?) to be able to program a textbox that when writing an information and giving it double click on that same textbox auto complete the inf...
asked by 28.11.2018 / 23:15
1
answer

Insert a record from a query built in a text string

Good afternoon, I am trying to insert records from a Cursor into a table in SQL but constructing the Insert statement in a text type variable. Within the values I have a field of integer type, several texts and a date, apparently I am with so...
asked by 17.02.2016 / 18:15
6
answers

Query the current date in Sql Server

I have the date column with the data type DATE ; I have stored data from 2018-01-01 00:00:00.0 to this date. At the time of making a query I would like to know how I do it so that it shows me only the data of the current date....
asked by 12.09.2018 / 22:42
0
answers

insert in two tables at the same time [closed]

I have a news table and a table photo news is to say that a single news can have many photos my question is how to make an insertion for example a single news story has 5 photos and must keep the news and photos at the same time; also want to...
asked by 26.09.2018 / 22:16
2
answers

Join with 5 tables in SQL Server [closed]

I have 5 tables that have transactions, between the columns of each table is "Date" which is the date of the transaction. I need to make a select where I can buy the 5 tables and see if they have transaction for a predetermined date range.  ...
asked by 21.09.2018 / 23:22
1
answer

Mirror Sql Server Ip Public

Dear I have a winform application vb.net that uses sql server some clients use public ip and port to connect to the engine. How to cover the replication or mirror mode of the engine in case the connection fails. The idea is to have 2 Vps servers...
asked by 09.07.2016 / 16:16
0
answers

Error making an SQL query with JavaScript

I'm trying to do a SELECT from node.js to get an error from a table of "errors" but I get the following error and I do not know what else to do or what is due.    UnhandledPromiseRejectionWarning: RequestError: Could not find stored   procedu...
asked by 02.10.2018 / 00:43