Use My Guitar Shop Database  Use Microsoft SQL Server Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4,   'American Express', '378282246310005', '04/2019', 4);   SET @OrderID = @@IDENTITY;   INSERT OrderItems VALUES (@OrderID, 6, '415.00', '161.85', 1);   INSERT OrderItems VALUES (@OrderID, 1, '699.00', '209.70', 1); Here, the @@IDENTITY variable is used to get the order ID value that’s automatically generated when the first INSERT statement inserts an order. If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

Trigger please

Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. note : Note: Sql code need not java  don't waste my time by giving java code

Branch Table BranchNo Name B001 Location 567, Kileleshwa 890, Karen 894, Rongai Kileleshwa BO02 Karen ВООЗ Rongai i). Write appropriate SQL statement to display all staff who work at BranchNo "BO02"

Chapter 16 How to manage transactions and locking Excercises using the My Guitar Shop Database Use Microsoft SQL Server Write a script that includes two SQL statements coded as a transaction to delete the row with a customer ID of 8 from the Customers table. To do this, you must first delete all addresses for that customer from the Addresses table. If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

EXAMINE THE TRIGGER BELOW IS IT CORRECT? IF NOT MODIFY Create test to show that the triggers are correctly implemented, do the following: Truncate the Transaction table Reset the Tx_Nbr sequence back to 1 Update the Account table, setting the Balance back to zero Re-run the INSERT statements for the transactions Use simple queries to demonstrate that the results in the Transaction and Account tables are as expected GIVEN THE TRIGGER BELOW: Trigger to enforce the referential integrity for the Transaction Ref_Nbr:  Deposit or Withdrawal transaction to Bank Branch Bill Payment, Debit Purchase, or Return transaction to Merchant CREATE TRIGGER Transaction_RefNbr_Check BEFORE INSERT OR UPDATE ON Transactions FOR EACH ROW DECLARE     TxRefNbr_count INTEGER; BEGIN   IF:NEW.TxTypeCode = ‘D’ OR :NEW.TxTypeCode = ‘W’ THEN          SELECT COUNT(*)INTO TxRefNbr_count          FROM BRANCH          WHERE BranchNbr=:NEW.RefNbr;       IF TxRefNbr_count = 0 THEN…

SQL   give the algebraic form of these queries:   //agregation select count(enfant_id) as "nombre enfants n'ont pas besoin d’aliment de substitution" from enfant where déjeuner='0';   select nom_ag "nom",prénom_ag "prénom",nb_heure_par_se "heures par semaine",   count(agents_id) "nombre des agents" from agents_entretien group by jour; // union select nom_en, prénom_en,'fils' as fils_ou_parent from enfant union select nom_ac,prénom_ac,'parent' as fils_ou_parent from parent_actual; select nom_en, prénom_en,'fils' as fils_ou_parent from enfant where enfant.parent_id='2' union select nom_ac,prénom_ac,'parent' as fils_ou_parent from parent_actual where parent_id='2'; // intersection select * from agents_entretien where jour in(select jour from nettoyage) INTERSECT select * from agents_entretien where jour in(select jour from nettoyage); //division select * from agents_entretien,nettoyage where agents_entretien.jour=nettoyage.jour group by nom_ag having count(*)=(select count(*) from…

Task 3: The Marketing team wants to collect emails of the users on InstantStay. However, the team needs a SQL statement to execute inside their programming environment. You need to create a statement that they can easily run the EXECUTE command to return a single column table containing the USER_EMAIL addresses. Task: Create a prepared statement for use with the EXECUTE command.

Problem Your task is to write an SQL query that uses SQL's time constants to dynamically determine the timezone the database server is configured to use. Your query should return the timezone as a single string value with the timezone offset relative to the Coordinated Universal Time (UTC). The single output column should be named tz_offset, and the value should be in the form: UTC: where and use two digits in 24-hour format, padded with leading zeroes if necessary. Example: if the server used India's timezone the output should be: | tz_offset | | UTC+05:30 (1 row) query.sql> init.sql 1