Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/new_insert_into_product_history.sql

Created April 26, 2022 20:01
Show Gist options
  • Save vvgsrk/26fa85589592cee690533de104cb5937 to your computer and use it in GitHub Desktop.
Save vvgsrk/26fa85589592cee690533de104cb5937 to your computer and use it in GitHub Desktop.
Download ZIP
Insert a new record to product history table
Raw
new_insert_into_product_history.sql
INSERT INTO product_history (product_id, product_name, price_per_unit, basic_unit, is_stock_limited, is_active_for_sale, __event_ts, __load_ts)
VALUES(1009, 'Paris Coffee', '3 EUR', '1 piece', 'No', 'Yes', DATEADD(hour, -1, DATEADD(Day ,-1, CURRENT_TIMESTAMP())), CURRENT_TIMESTAMP());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment