Contoh Stored Procedurs, Function, and Triggers

Contoh Stored Procedurs, Function, and Triggers

NIM/NAMA  = 10410100212/AGUS CAHYONO

Dosen  = Tan Amelia

Tugas  = Contoh Stored Procedurs, Function, and Triggers

1. Contoh Stored Procedure dengan Parameter IN

CREATE PROCEDURE OrderShipCountry @ShipCountryname varchar(20) AS  

SELECT OrderID, CustomerID, EmployeeID, ShipName, ShipCity

FROM Orders

WHERE ShipCity like @ShipCountryname

EXEC OrderShipCountry 'Madrid'

Hasil OutPutnya :

Baca Selengkapnya ....