neworder.sql

Mastering VBNet Include Source Code

CREATE PROCEDURE NewOrder
@custID nchar(5)
AS
INSERT INTO Orders (CustomerID, OrderDate) VALUES(@custID, GetDate())
RETURN (@@IDENTITY)
GO