Questions tagged as 'sql-server'

Tagged questions
1
answer

execute SQLServer and MySQL stored procedure from Java

good morning / afternoon / evening at the time you see this post the issue is that I do not know the syntax to call a SQLServer stored procedure from java example //para llamar a un una sentencia insert/update/delete/select utilizo PrepareStat...
asked by 22.07.2018 / 09:58
0
answers

How to create a Trigger in a table that is triggered when modifying the data and that reports the primary key of the modified field?

I would like to know how I can return using a trigger the value of the primary key of a field when updating. I'm working with SqlServer.     
asked by 22.07.2018 / 19:49
1
answer

Get% compliance from a column in Power BI

I'm doing a column calculated in Power BI called Compliance, the column is formed as follows: Cumplimiento = IF('SLA Service Now'[Ha producido una infracción]=FALSE(),( DIVIDE(COUNT('SLA Service Now'[Status SLA]),[Conteo de tickets],90)))...
asked by 20.07.2018 / 17:44
1
answer

Register data from nested tables with transaction VB.NET

My problem: I have a database and several related tables, inside a button I want to add more than two tables instantly in nested form: I explain: (In this example) I have a main and a secondary table, they are related, and what I want to d...
asked by 23.07.2018 / 23:34
0
answers

Warning: sqlsrv_has_rows () expects parameter 1 to be resource, boolean given (using inner join)

I need help with this, I did not come across any surprises until I had to perform a inner join . It's the first time I use one with php. Maybe my syntax is incorrect. <!doctype html> <html> <head> <meta charset="utf-8">...
asked by 24.07.2018 / 03:41
0
answers

SQL - Read a txt file and separate rows by blanks

Hello friends I am trying to process some txt's that I receive from a system other than mine, I need to take this information and store it in a table within my SQL Server , the question is that my data It comes separated by 2 characters, very l...
asked by 11.07.2018 / 23:36
0
answers

SQL server Update incomplete

I am trying to create a table with editable fields and at the end of the table that has an update button, this is my sentence when I pass the update (the table and the update I try to keep it as simple as possible afterwards. It's hard to see wh...
asked by 11.07.2018 / 21:32
0
answers

Double quotes, backslash, replace in sql

a help here, I try to replace double quotes (") with (\") backslahs + double quotes, in the database to be able to take it to JSON, but I do not understand gives me this error Msg 8152, Level 16, State 14, Line 20 String or binary data would b...
asked by 11.07.2018 / 22:08
1
answer

How to capture two data AND get lost time?

Hi guys, I have a question a bit urgent and I will present the case so you can understand me try to be as clear as possible, I have a database connected to a PLC that gives me the speed of 3 machines with the time and the date of that spee...
asked by 10.07.2018 / 17:10
1
answer

Android Studio and SQL Server

I want to connect an application with sql server, but I get the following error. Does anyone know what it can be? 07-08 01:27:29.427 3890-3890/? E/AndroidRuntime: FATAL EXCEPTION: main Process: com.itasur.julio.sqlserver, PID: 3890 jav...
asked by 08.07.2018 / 07:35