+ 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?
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
+ 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.
+ 1
Its a college assignment,
Thank you for the help sneeze
0
What is it you do not understand.
Show us your attempt first.
https://www.w3schools.com/sql/sql_stored_procedures.asp