Column types

CREATE TABLE Orders
(
OrderId INT NOT NULL,
ProductName VARCHAR(50) NOT NULL,
OrderDate datetime NOT NULL DEFAULT NOW(),//( rubbish )
PRIMARY KEY (OrderId)
)