Questions tagged as 'sql-server'

Tagged questions
2
answers

Procedure delete join between tables

Good afternoon, I have the following Tb.Customer environment where a client has N processes in Tb.Process, N moves in Tb.Andamento, and N attachments in Tb.Annexo. Ineedtomountansqlstatementthatdeletesaclientbythecode" ClienteID ", del...
asked by 05.12.2017 / 17:11
1
answer

SQL command to add the vacancies occupied on a specific day of a parking

Personally, I'm having a little problem finishing a college job and would be of great help if you helped me with a small VIEW. Here are the fields of the parking table: CREATE TABLE Seg.Estacionamento ( valor_hora decimal(4,2), numero_vagas...
asked by 23.11.2017 / 00:50
1
answer

Doubt - Query SQL Server 2012

Good morning! I have a query below that I need to bring inside the case only when the TarVencimento is smaller than today's date (so far I have been able to do it), but only when today's date is until the 5th day after the date of maturity. E...
asked by 22.11.2017 / 12:20
0
answers

Error - Trying to get property of non-object - Laravel

I changed my production bank, so the production base returns the objects my local database already appears in this message MyController project /** * Lista todos os projetos ativos * @access public * @param NULL * @return arrProjetos par...
asked by 06.12.2017 / 18:10
0
answers

Synchronize MySQL and SQL SERVER through PHP script

I need to synchronize SQL Server (Master) with MySQL (Slave). I have already found some ways to do this on the internet, such as the native SQL Server feature "Linked Server" or that APP for windows DBSync. But I wanted to know if you can do...
asked by 24.11.2017 / 20:17
2
answers

Change column data [closed]

How can I change the column data? I wanted to change some bits to false but I do not know how. using (SqlCommand cmdadd = new SqlCommand("INSERT into Usuarios (Cadastro) VALUES (@Cadastro)", connection2)) { cmdadd.Parameters.Add(ne...
asked by 19.11.2017 / 13:39
0
answers

Order of execution of searched CASE expression

The CASE WHEN has two ways to function, with simple expressions and searched:    The expression simple CASE compares an expression with a set of   simple expressions to determine the result.       The expression searched CASE eval...
asked by 14.11.2017 / 16:39
1
answer

Doubt with calculation of the profit margin between values

I have a sql query where I am showing the cost value and sales value of the product, I would like to show the profit margin between cost and sales values, for the quantity of items sold select a.RAZAO_SOCIAL, d.CODIGOCOMERCIAL, d.DESCRICAO AS...
asked by 30.10.2017 / 18:22
0
answers

SQL Server Driver in WAMP

I'm trying to install the SQL Server driver for php 5.5.12 (x64) but have not yet been able to I downloaded the dll's from the official site , and added it in php.ini They appeared in the list of PHP extensions but did not appear in php i...
asked by 30.10.2017 / 13:09
0
answers

How to import record from only one CSV column within a Sql server column?

I have a csv file with several columns "ID, ROOTNAME, DATA" and want to insert the record of a "RED_NAME" column that is inside the csv file in my sql server table named "DATA". My "DATA" table in the Sql server has several columns "ID, NAM...
asked by 30.10.2017 / 14:01