Questions tagged as 'sql-server'

Tagged questions
3
answers

Error getting multiple results from a subquery - SQL

I want to make a select, with 3 columns, the first is an id , the second is a name , and the third another name . The objective is to obtain in a final table that I already have mounted, a column that contains one or another name dependin...
asked by 25.11.2016 / 13:59
1
answer

SQL script with column '-1'

I have this SQL script: create view transactview as ( select SUM(quantity) as venta,tag,shift_id,pump,nozzle from transactions where tag in (100,200,300,400) group by tag,shift_id,pump,nozzle union select SUM(quantity) as venta,'-1',shift_...
asked by 12.08.2016 / 16:13
1
answer

Problems the query takes me as Alert Injection SQL

Thank you in advance for answering. The problem is that when I run the following query I get an alert injection SQL . \!/ ALERTA !!!!! [09 Aug 2016 10:45:30] <br> TIPO: SQL INJECTION-INTERNO <br> URL ATAQUE: /gci//workflowgest...
asked by 09.08.2016 / 18:06
3
answers

ON DELETE CASCADE with Trigger AFTER DELETE

I have a problem when it comes to making a few tables for tables and I hope they can help me. Let's imagine that I have a Grandfather table created in the following way: CREATE TABLE ABUELO{ IDABUELO INT PRIMARY KEY } And...
asked by 29.05.2016 / 00:45
2
answers

SQL SERVER Transaction File LDF

I have started using sql-server , in the database I have configured the transaction file to grow by 10% as needed, but up to a maximum size of 2Gb. When the file of transactions (ldf) reaches the established limit of 2Gb, does it stagna...
asked by 28.03.2016 / 10:27
3
answers

SQL Server 2008, restore .back without management studio

I explain a little, I have an application that I install in the client machines along with the sql express (without management stdudio), the dilemma is that I have to restore a backup, but I do not know how to do it without the management studio...
asked by 03.06.2016 / 23:56
1
answer

Fill textbox with combobox

I'm trying to fill TextBox from a% of ComboBox , my problem is that I show the data of ComboBox and fill the TextBox but when I change the item in ComboBox the data of TextBox remain static. I share th...
asked by 03.12.2018 / 19:20
1
answer

Is it possible to prevent a job from running again while still performing tasks?

I need to create a Job on sql server that runs every 5 minutes. The job must execute a stored procedure that verifies some records in the database, which, depending on its status, must perform the execution of other stored procedures. The proble...
asked by 26.12.2018 / 22:38
1
answer

How to concatenate a value to enter it in an update?

I have a query, I'm trying to concatenate this update update tdato set valor= (select max(valor)+1 from tdato) the value that returns me plus a text, try trying to contact it in the following way: update tdato set valor = ('AG-')+convert(...
asked by 05.12.2018 / 20:11
1
answer

Comparisons of dates in SQL Server

I am trying to make a query between a range of dates, and when I use the> = to today's date (11/26/2018) if it shows me, instead if I use only the = to the date of today it does not show me anything, when it is not logical because there is no da...
asked by 26.11.2018 / 11:23