Generation

text to sql syntaxSun, 09 Jul 2023

Crear una Transaccion que realice la creacion de un nuevo cliente(Customer) y una nueva orden asociada a ese cliente(no crear detalle de orden)

BEGIN TRANSACTION; INSERT INTO customers(customerName, contactName, address, city, postalCode, country) VALUES('Cardinal','Thomas','Skagen 21','Stavanger','4006','Norway'); INSERT INTO orders(customerID, orderDate) VALUES('Cardinal','Thomas','Skagen 21','Stavanger','4006','Norway'); COMMIT TRANSACTION;

Want to kickstart your project?Use the new AI Studio to create your code