Tag: cursors

Found 54 results for 'cursors'.

1) sql-server - How to update price where value of rows exist in value of column in sql?
2) sql-server - T-SQL CTE Compare previous non-NULL and current row to filter out by difference value
3) mysql - Recursive Query in MySQL using stored proceedure and CURSOR
4) oracle - Oracle strong ref cursor with dynamic sql
5) oracle - Determine structure of out cursor
6) sql-server - Dynamic conversion of long data to wide with multiple columns
7) sql-server - Can two sessions create #temp tables with the same name?
8) oracle - Facing error 'invalid SQL statement' while working with cursor variables in PL/SQL
9) sql-server-2008 - Dynamic SQL To Send HTML Email
10) sql-server-2008-r2 - To use a cursor or something else in my while loop?
11) sql-server - Why choose a top query and temporary table instead of a cursor for a loop?
12) mysql - if exists, update else insert, with cursors in stored procedures only returns 1 row
13) sql-server - Getting two or more column values through a Cursor SQL Server
14) mysql - MySQL - UUID/created_at cursor based pagination?
15) postgresql - Bug in PL/pgSQL function creation
16) sql-server - script all triggers in a database
17) sql-server - sp_cursoropen and parallelism
18) sql-server - Modifying a result set in a Stored Procedure, then returning that modified set
19) sql-server - Static Cursor and Where current of
20) mysql - Additional Select statement within Cursor terminates looping unless Select statement returns a results for all cursor rows
21) postgresql - Are PostgreSQL cursor bound to connection?
22) sql-server - How to drop a procedure across a lot of databases (SQL Server 2016)
23) sql-server - Cursor causes SSMS to crash
24) sql-server - Replacing a Cursor with a single Query possible?
25) sql-server - Cursor Performance in New Server
26) sql-server - Converting Cursor based filtering logic to CTE based
27) sql-server - Using cursor to update if exists and insert if not
28) postgresql - Query Performance for Reports in PostgreSQL
29) sql-server - Is it possible to disable use of fast forward-only cursor on server side?
30) oracle - Is the data fetched by an explicit cursor immutable in PL/SQL?
31) oracle - Pass (comma separated) -yet single parameter to cursor
32) sql-server - Performing a "Spread Negitive" over a dataset
33) sql-server-2008-r2 - Convert all ntext columns to nvarchar(max)
34) mysql - Why is this MySQL proc using cursors failing to retrieve results?
35) db2 - DB2 : Load from cursor Dynamic query
36) db2 - DB2 Dynamic Load from cursor
37) sql-server-2008 - Declaring cursor to loop over some values in SQL Server 2008 R2
38) sql-server - sp_cursoropen and parallelism
39) postgresql - How can I efficiently delete records when a counter reaches zero in PostgreSQL?
40) t-sql - Infinite loop in CURSOR
41) mysql - How to arrange rows selected in MYSQL query?
42) sql-server-2008-r2 - SQL Server index causing incorrect behavior on cursors
43) sql-server - Auto increment a value using cursor in SQLServer
44) sql-server - sp_cursorprepexec causing 53 million reads?
45) sql-server - sp_cursoropen chooses terrible execution plan
46) sql-server - Adding an ID column based on two other columns
47) sql-server - Can't reduce cost of query plan and get rid of Key Lookup because of cursor
48) sql-server - SQL Server - Cursor and Dynamic SQL
49) sql-server - Why does CURSOR_STATUS return unexpected results for an output cursor inside the stored procedure that created it?
50) oracle-11g - Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB