CreateVendorTabole.sql

USE TSQL2012;

IF OBJECT_ID('vendor') IS NOT NULL
  DROP TABLE vendor

CREATE TABLE Vendor
(
    VendorID INT IDENTITY PRIMARY KEY,
    VendorName VARCHAR(32),
    VendorEmail VARCHAR(200)
);

INSERT INTO Vendor
	VALUES('Dell', '[email protected]');
INSERT INTO Vendor
	VALUES('IBM', '[email protected]');
INSERT INTO Vendor
	VALUES('Microsoft', '[email protected]');
INSERT INTO Vendor
	VALUES('Oracle', '');
INSERT INTO Vendor
	VALUES('Intel', NULL);
INSERT INTO Vendor
	VALUES('Apple', '[email protected]');