Questions tagged as 'sql-server'

Tagged questions
0
answers

Insert SQL Server Column receives no value

I'm trying to insert into a simple table, but a field of it, is not saving the value I'm passing to it, and the strangest thing is that all other columns get right. Example INSERT TabelaExemplo (id, nome, outroId) values (1,'Gabriela', 2) I...
asked by 02.05.2017 / 15:22
0
answers

Python + django list + HTML select option

Good morning guys, I need your help on a code I'm developing in python + django Here's my problem: I have a function in views.py where I make a select of Name in the customer table and put the data (fetchall ()) inside a list, and send thi...
asked by 02.05.2017 / 14:31
1
answer

Update and maintain update code when it is repeated

I've made this update: declare @rx_num varchar(20), @id_oit_max int, @id_exm_rea int, @id_xfc_novo int, @id_xfc int = 0 declare oit_cur cursor for select pl.rx_num, er.id_exm_rea, er.id_xfc from t_cmo_planilha_leitura pl inner join T_CMO_EXA...
asked by 26.04.2017 / 23:39
1
answer

Condition (if) does not work to insert data

I made this query to insert data. I should only enter data if there is nothing in the OIT1980 table. Then I mounted a cursor and ran and put an IF. If I remove the IF, it works, but if I leave it there, I do not know if the way I compare is corr...
asked by 24.04.2017 / 21:03
1
answer

Error trying to create a Proc in the database

I'm trying to run a Stored Procedure in the database and it's giving this message:    Can not grant, deny, or revoke permissions to sa, dbo, entity owner,   information_schema, sys, or yourself How do I resolve this? If Proc already ex...
asked by 17.04.2017 / 21:36
1
answer

Updating the SQL database in the MVC project

I made a column change in my BD SQL in my ASP.NET MVC project. I changed a column from Cliente_RG (INT) to Cliente_Bairro (String) . In SQL it was OK to change. In the project, in all tables (I think) the associations were change...
asked by 06.05.2017 / 15:33
0
answers

Connect By on SqlServer

I have a query that works in Oracle but is not working in SQL Server. The table I have saved has a start date and end date on the same line, but when it goes from one day to the next, I needed to look at how much time I had in a day Dt_I...
asked by 25.04.2017 / 15:49
0
answers

Data Synchronization

Good afternoon, guys. I have a small problem: I created a C # application for managing a transport company. Then they asked me to also create a web page from where the customer informed the number of their process, could see the progress of thei...
asked by 07.04.2017 / 12:34
0
answers

Can not find column 22276451.

Good morning, I'm developing a code that can defer the X and Y values of a chart I inserted into ASP.NET. For this I made a query to the sql server to be returned to the average of a column, until the following error appeared: Can not find colum...
asked by 06.04.2017 / 11:29
0
answers

database vendor code: 521

I am not able to run these queries in sql 2008 I took the test in 2014 and it worked could someone help me? I'm too close to the bridge to find a solution. Follow the query: SELECT D1_COD, D1_FORNECE, A2_NOME, --1ª COMPRAS-- MIN(COMPRAS.D1_...
asked by 18.04.2017 / 19:57