+ 1

SQL Stored

I have to write a script "storedprodure.sql" that contains the code for creating a stored produre 'stats_cliente' that takes a client id as argument and shows statics for contracting customer services in the organization, as show in Anexo II. The anexo II have this: CALL stats_cliente(12) Someone know how to do this?

26th Jan 2021, 3:25 PM
Marta Gomes
Marta Gomes - avatar
4 Respostas
+ 1
sneeze I need to create new names or if i just select all i want to show isnt the same? I dont really understand this last part of the class
26th Jan 2021, 5:35 PM
Marta Gomes
Marta Gomes - avatar
+ 1
Is this an assignment in sololearn or a school assignment ? As I read it. You need to write a script. That creates a stored procedure. The stored procedure should show the statistics of a client as shown in Anexo II. The client ID is a input parameter of your stored procedure. I don't known, what is shown in Anexo II.
26th Jan 2021, 7:18 PM
sneeze
sneeze - avatar
+ 1
Its a college assignment, Thank you for the help sneeze
26th Jan 2021, 7:39 PM
Marta Gomes
Marta Gomes - avatar
0
What is it you do not understand. Show us your attempt first. https://www.w3schools.com/sql/sql_stored_procedures.asp
26th Jan 2021, 5:29 PM
sneeze
sneeze - avatar