Questions tagged as 'sql-server'

Tagged questions
1
answer

Slow Query - SQL Server 2012

The query below takes an average of 30 seconds to execute. I know that most likely it will be the various or and like , but I am looking for the log table and not always the id will be the same, for I used the like . How do I adjust this q...
asked by 07.08.2017 / 21:55
1
answer

SQL Server Create a filter in a DateTime field, bringing the previous 24 hours (not counting the current time)

Good evening, I'm having trouble putting a date filter, I have a query where I bring the information of CD, Crane and DtRegister (datetime) In this query I am already filtering the 24 hours between the current day and 24 hours before, GRU_DT_R...
asked by 07.08.2017 / 03:16
0
answers

Connection to the slow database

I have a program in C # that when the start and ask to show me the data inserted in the Sql Server takes to open, but after this time is already faster. Is there a way to be faster first time? My connection is made this way and only use store...
asked by 02.08.2017 / 14:13
2
answers

C # and Sql Server, inserting with proc using BEGIN TRAN

Good evening! I am inserting a record using C # and Windows forms , I am using a proc that inserts into two tables at the same time, the code is working, but I created a rule that the store can only have only 1 manager, I threw a select in t...
asked by 02.08.2017 / 03:41
1
answer

How to update a field from a Database table using a Stored Procedure?

I basically have a database table, which has a field called DESCRIÇÃO and the table is called Tabela123 I have 10 records in this table, and in the DESCRIPTION field I have the sentences: Hello, are you ok? goodbye and thank...
asked by 08.08.2017 / 13:00
2
answers

How to remove duplicate dates in sql?

Good morning, I need some help for the following problem, I have this code Whichgivesmethefollowingresult,howeverIwouldliketoremovetheduplicatedates Thanks in advance.     
asked by 08.08.2017 / 13:22
0
answers

Control X-axis markup in date data graphs

I have records in the database and a graph where I can preview them. The graph is data x Voltage in volts. When I have few records in the table the graph shows exactly the date recorded in the bank on the X axis, but over the time I add more...
asked by 10.08.2017 / 21:52
1
answer

Consuming webservice per SQL Server procedure?

I'm using sql server 2016 to consume webservice per store procedure. I have a webservice in JSON returning the following: [{"nome":"Rebecca","email":"[email protected]","ra":"12345"},{"nome":"Caroline","email":"[email protected]","ra":"23...
asked by 21.07.2017 / 13:55
0
answers

SQL needs CAST to return values in query

Gentlemen, I manage a PHP application that uses SQL Server 2008 database. After a database server migration queries only work by doing the conversion with CAST and selecting one by one in SELECT . I do not use CAST I get this error....
asked by 21.07.2017 / 17:24
0
answers

SQL Server Connection

I'm trying to connect directly to SQL Server for testing, but at the time of the "Register" test by clicking the button, the app simply hangs, is there something wrong with the code? package br.com.agemstar.testesql; import android.os.StrictMo...
asked by 24.07.2017 / 21:47