Posts by Lilian Kotvan • 19 points
2 posts
-
0
votes1
answer46
viewsQ: SQL Server - insert data after comparison of 2 tables
I have 2 tables where I want to compare the price of products: TABLE: PRODUCT produto preco A 4.5 B 6 C 10 TABLE: RANGE PRICE produto valor minimo valor maximo A 3.2 6.7 B 2.1 4.5 C null null I…
-
1
votes1
answer29
viewsQ: SQL SERVER delete record after UPDATE
I would like to know if you can delete the records from the source table after performing the UPDATE in another table, that is, delete the row (from the source table) that was used in the update of…