What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-22 04:39:12
insert into in DBT prehook
{%- macro profile_schema(table_schema) -%} {{ config(schema='profiles') }} {% set not_null_profile_threshold_pct = ".9" %} {% set unique_profile_threshold_pct = ".9" %} {% set tables = dbt_utils.get_relations_by_prefix(table_schema,... Add solution -
TypeScript 2021-11-12 05:38:23
constraints in sql
NOT NULL # Ensures a column cannot have a NULL value UNIQUE # Ensures all values in a column are unique PRIMARY KEY # Identifies a record in a table, is NOT NULL & UNIQUE FOREIGN KEY # References a unique record from another table CHECK # Ens... Add solution -
Other 2021-11-11 19:00:18
postorder traversal without recursion
1.1 Create an empty stack 2.1 Do following while root is not NULL a) Push root's right child and then root to stack. b) Set root as root's left child. 2.2 Pop an item from stack and set it as root. a) If the popped item has a right child and t... 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