Questions tagged as 'sql-server'

Tagged questions
0
answers

Connect MS SQL Azure with Python (RaspberryPi)

I'm having difficulty connecting to SQL in Raspberry Pi, using Python. I made this class: import pyodbc class MaximoNivel(object): def __init__(self, Ponto): self.Ponto = Ponto def Retorna(self): server = 'tcp:ser...
asked by 15.05.2018 / 18:59
0
answers

How to assign data in a cursor from an exec and not a select

Context: I have several files in a folder, so I do not want to put the path one by one, so I need to add my command variables. Set @nome_arquivo = '252203408.xlsx' Set @sql='SELECT * FROM OPENROWSET( ''Microsoft.ACE.OLEDB.12.0'...
asked by 17.05.2018 / 20:46
7
answers

Best data type to work with money?

I'm developing a project for commercial automation, using PAF-ECF and everything else. What would be the best data type to work with SQL Server and C # for money issues? Especially in relation to rounding and truncations. I imagine the bes...
asked by 13.02.2014 / 23:33
0
answers

How to Assign Vacancies from one table to Patients from another table

Galera for a project of dental consultations I need to relate two tables of patients and vacancies in order to assign the first patient who came in contact requesting a specific specialty (orthodontics, whitening, etc.) the first available wave...
asked by 21.05.2018 / 21:33
0
answers

Query schedule in sql

I have the following problem, I will receive a bank with "x" available positions in several specialties and another with "y" patients requesting those specialties follows the model of the tables below, would have to elaborate a query that would...
asked by 13.05.2018 / 00:08
1
answer

Limiting functions according to access level [closed]

I have form MenuPrincipal and FormLogon , where the latter, after performing login validation queries, calls the Menu and closes. I need to limit some buttons and controls depending on the access level of that user that just logged...
asked by 15.05.2018 / 06:31
0
answers

User and remote connection questions in SQL Server Management Studio

I created a remote connection from my database here at work so that I can access from home just by entering the company's fixed IP. Now I need to know if it is possible, for example: I have several users created, but I want only the user "query"...
asked by 08.05.2018 / 19:34
1
answer

SQL - Searching for XML data

I have a table where one of the fields is an XML ThestructureofXMListheBrazilianstandardschemaofCTE(KnowledgeofElectronicTransport)<cteProcxmlns="http://www.portalfiscal.inf.br/cte" versao="2.00"> <CTe xmlns="http://www.portalfiscal....
asked by 08.05.2018 / 17:29
1
answer

Sum with Negative and Positive Numbers - Sql Server [closed]

I'm trying to do the sum of positive and negative values in the SqlServer database, but the same thing done by the calculator returns a different value. I'm using SUM(NR_QUANTIDADE) The NR_QUANTITY column is of type float in the databas...
asked by 04.05.2018 / 14:32
1
answer

Connect in bank sql a bank postgres

Scenario: I have the database postgres A, however I need to connect to bank A from sql server 2017. How can I do this?     
asked by 10.05.2018 / 23:38