Questions tagged as 'cursor'

Tagged questions
1
answer

Comparison: CTE vs CURSOR

I do not know if this will be a question that many pose, but I have always had it in mind almost always. Normally when I need to deliver a corrective script to a client, used to only run once, I use a CURSOR , perhaps because it is mo...
asked by 24.12.2018 / 12:39
4
answers

Is it possible to change the color of the mouse cursor via CSS?

I know that it is possible to change the style (type) of the mouse cursor via the cursor property in the CSS. But does anyone know if it's possible to change the cursor color? In an application I would like to have the pointer c...
asked by 31.01.2014 / 21:37
1
answer

How to use contents of a vector to assemble the name of a file to be saved?

I have tried to use colnames() , names() and nothing works. My data is something like (however, I have 38,000 names and 38,000 columns): nomes <- c("nome105", "outro.nome_26", "qualquerCoisa") dados <- as.data.frame(matri...
asked by 10.05.2016 / 21:19
2
answers

How to smooth a curve and define ylim for a given function using ggplot2?

I got the following graph with the curve function: f1 <- function(x){x^4 - 6*(x^2)} curve(f1, xlim = c(-3, 3), ylim= c(-10, 5), ylab = expression(x^4 - 6*(x^2))) However, I would like to use the ggplot2 package to reproduce this same gra...
asked by 18.03.2015 / 20:23
1
answer

How to insert records through cursor?

I need to insert unique records by a field that has the unique identifier, with this I am using cursor; however, the unique identifier will not add according to the inserts. ERROR: You are duplicating and inserting only the first record....
asked by 28.12.2018 / 12:11
1
answer

Use tuple with parentheses in query in django

I made a cursor to get the parent menus of my application, then I want to iterate each parent menu and get the menus associated with it. However, passing parent with parameter, the second course does not work. from django.db import connection...
asked by 01.07.2018 / 00:24
1
answer

Sql server transform a column into several rows

Good morning I have a table called books that has 3 fields, Code, Name and Chapters Example content: 32 - Jonas - 4 I need that after the select return the following result to me Codigo e Capitulo 32 1 32 2 32 3 3...
asked by 02.02.2017 / 10:51
1
answer

Bug script to delete the entire SQL SERVER database

I have the following script to drop EVERYTHING from the database, but in one of the database I have the processing that needs this script a bug happens, for some reason it can not run the first time I run, but in second wheel without any hindran...
asked by 19.12.2016 / 16:54
2
answers

Doubt with cursor in memo

In my project VCL , I have a TMemo with the following text (| is cursor): | | |Hello world | | | | |test | | | | | When I press Down...
asked by 31.10.2016 / 12:48
1
answer

Assign execute command to a variable

I need the return of the execute command to be assigned to variable @PAGO because I will insert it into a temporary table only what returns is the script, not the value. DECLARE @COMANDO_COMANDO_PAGO VARCHAR(2000) SET @SITUACAO = 'PAGO'...
asked by 12.10.2014 / 19:59