USE [Medium]
GO

DELETE FROM [Post_Tag_Junction]
DELETE FROM [Posts]
DELETE FROM [Tags]


INSERT INTO [Tags]
VALUES
	('Angular'),
	('React')

INSERT INTO [Posts]
VALUES (
	'angular-one-time-binding-syntax',
	'Angular one-time binding syntax',
	 'Angular 1.3 shipped with an awesome new performance enhancing feature - one-time binding.',
	 1,
	 GETDATE())

INSERT INTO [Post_Tag_Junction]
VALUES
	('angular-one-time-binding-syntax', 'Angular'),
	('angular-one-time-binding-syntax', 'React')


SELECT *
FROM [Posts]
WHERE [Slug] = 'angular-one-time-binding-syntax'

SELECT [TagName]
FROM [Post_Tag_Junction]
WHERE [PostSlug] = 'angular-one-time-binding-syntax'