Questions tagged as 'sql-server'

Tagged questions
1
answer

Update via value difference by id

I'm trying to perform an update through this select, where I see the different data from the pen_cadastro table, but when trying to perform an update, it presents errors: [MYSQL] UPDATE: begin transaction UPDATE pen_cadastro as CADAS...
asked by 25.07.2017 / 16:37
1
answer

Catch latest information sql server by netbeans jdbc

I am using this way to try to bring the latest information registered in the sql server, but for some unknown reason it is not working. I searched in several forums and apparently the same method I'm using is used: Class.forName(Auxili...
asked by 01.11.2017 / 12:22
2
answers

New procedure is not displayed in SQLSERVER

Follow the steps in doc in microsoft: link I changed the permissions but could not display "new procedure" when clicking the new procedure folder     
asked by 28.06.2018 / 02:26
1
answer

How to put zeros after the digitizer digit - sql server

I need to put 9 zeros after 02:    0207200000053P 02- here are the zeros - 07200000053P that is coming from a variable called @vNossoNumero . How do I do this? Variable Select @vNossoNumero = case when @Conta='0000064-7' t...
asked by 28.08.2018 / 15:46
1
answer

Relational Tables of Orders in C #

Good morning, I'm developing a request screen where products will be added to the request, but I can not imagine a way to save the order items to a table, how could I relate the product registration table to the table of the requisition? I'm...
asked by 15.04.2018 / 16:46
1
answer

Catch only the value and format in 2 decimal places [closed]

Well, I have a python script that queries two different bases for checking values per day, one in SQLSERVER and one in Postgres. I used an if to tell if the values were different and if so, to warn. What happens and what was alarming even...
asked by 07.11.2018 / 19:44
1
answer

Add multidimensional array as an array item

I'm working with laravel and I'm implementing a menu based on permissions, I'm retrieving menu data from a table in my database. I created a model and in it I'm doing the logic to retrieve the menu items and if the item has a parent_id column wi...
asked by 11.12.2017 / 18:39
1
answer

Delete period without tag Between

Good afternoon, Is there any way to exclude a period without using BETWEEN ? x NOT BETWEEN HorFim AND HorIni and y NOT BETWEEN HorFim AND HorIni Where: x = hora inicial digita pelo usuario. y = hora final digita pelo usuar...
asked by 23.08.2017 / 17:12
2
answers

Assign value in SQL variable

How do I make a select that assigns the value "10" in all of the games column? NOTE: Do not give update in the table. /*minha_tabela*/ codigo jogos --------------------- 1 10 2 10 3 10...
asked by 15.04.2017 / 04:18
1
answer

You can disable the primary key of a table

I wanted to know if it is possible to disable a primary key in a table. I will explain the reason for disabling the primary key. I have a table B that has a foregein for table A, plus I need to delete table A without having to delete the foregei...
asked by 07.12.2015 / 19:54