Questions tagged as 'sql-server'

Tagged questions
2
answers

UnixODBC: Decimal formatting problem

I've set up a server with CentOS 7, SQL Server 2017, and UnixODBC In tsql, the numbers are correct. But when I look at isql, the decimals are separated by a comma (,) instead of a period (.). How can I fix this? Q: What I really want...
asked by 26.06.2017 / 21:58
1
answer

Select, by quantity, items that match conditions

I'm having a question when setting up a query. I'll set up a fictional scenario to demonstrate. I have the quantidadeQuestoes table with the fields: cod_level cod_category cod_dificulty quantity And I have the questo...
asked by 11.08.2015 / 19:33
1
answer

Update in date field updating calculated field

I have in my table a field of DtManagement of type DateTime. In addition to this I have three other fields computed as follows: DAY: (datepart (day, getdate ()) MONTH: (datepart (month, getdate ()) YEAR: (datepart (year, getdate ())...
asked by 05.08.2015 / 14:52
2
answers

Display zero in group by SQL Server

I have a table that calls Ordem , it has a field that represents the Status of the service order (0 to 7), I need to plot a graph in Ireport, but I wanted to display in the caption the name of the status when the value is zero. The sele...
asked by 17.08.2015 / 15:26
1
answer

Pass multiple parameters to an SQL query

Let's say I have the following CPF's: 65568752877 86924355382 55317961378 82331493146 I would like to pass them as a parameter in a query SQL , I am trying as follows: SQL Excerpt ... " AND Beneficiario.Codigo IN ('"+codig...
asked by 07.08.2015 / 14:15
1
answer

SQL Server PDO error: There are no more rows in the active result set. Since this result is not scrollable, no more data may be retrieved

I'm trying to get records from a table and write to another of the same type, but I'm having this error:    There are no more rows in the active result set. Since this result set is not scrollable, no more data may be retrieved. The code...
asked by 27.04.2017 / 17:15
1
answer

Class C # as parameter in SQL Server [closed]

asked by 12.04.2017 / 01:39
3
answers

Disable SQL Server Column Identity

How do I disable the identity property of a column in SQL Serve r? I've tried: SET IDENTITY_INSERT ON/OFF But it did not work. I do not know if it only serves for insertion, but I need to do an update.     
asked by 10.10.2016 / 14:50
2
answers

Save without accents and uppercase SQL Server

I am creating a database, where I need to save all varchar fields in uppercase. Searching the internet, I found the following collate that would work, but it still keeps saving with accents and in uppercase and lowercase. Here's the example: C...
asked by 03.10.2016 / 19:10
1
answer

Sql Server Stored Procedures [closed]

I'm starting to develop an application, basically it's a business management control. The application will issue NFC-e, NFe, will control inventory, financial and etc., the database will be hosted on Azure. I started by modeling the database and...
asked by 30.09.2016 / 15:34