What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-10 19:50:09
mysql fill in missing dates
MySQL doesn't have recursive functionality, so you're left with using the NUMBERS table trick - Create a table that only holds incrementing numbers - easy to do using an auto_increment: DROP TABLE IF EXISTS `example`.`numbers`; CREATE TABLE `example`.`... Add solution -
SQL 2021-11-10 04:49:15
ms sql how to see active job current run time
SELECT ja.job_id, j.name AS job_name, ja.start_execution_date, ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id, Js.step_name FROM msdb.dbo.sysjobactivity ja LEFT JOIN msdb.dbo.sysjobhistory jh ON ja.job_histor... Add solution -
Other 2021-11-07 03:23:13
oracle initialization varchar collection
DECLARE TYPE by_string_t IS TABLE OF INTEGER INDEX BY VARCHAR2(100); l_stuff by_string_t := by_string_t ('Steven' => 55, 'Loey' => 555, 'Juna' => 5555); l_index varchar2(100) := l_stuff.first; BEGIN DBMS_OUTPUT.put_lin... Add solution
Best helpers
Ranking is empty