Code:
CREATE PROCEDURE NEW
AS
BEGIN
CREATE TABLE Products (ProductID INT, 
CategoryID INT,
[Product Name] VARCHAR(30),
Price SMALLMONEY,
[Quantity In Stock] INT
PRIMARY KEY (ProductID)
)
END