AnnouncementsSchema.sql

DROP TABLE Announcements

CREATE TABLE Announcements (
	AnnouncementId   INT			NOT NULL PRIMARY KEY IDENTITY(1,1),
	Title		     NVARCHAR(250)  NOT NULL,
	Body			 NVARCHAR(4000) NOT NULL,
	AnnouncementDate DATE			NOT NULL
);

INSERT INTO Announcements
	VALUES ('Announcement 1', 'Announcement 1 Body', GETDATE()),
		   ('Announcement 2', 'Announcement 2 Body', GETDATE()),
		   ('Announcement 3', 'Announcement 3 Body', GETDATE())