SQL Reserved keywords

If you have a column named Key then you will have issues when doing this:

select * from Sectors where Key = 'bagder'

"Incorrect syntax near the keyword 'Key'."

This is because Key is a reserved keyword in SQL.   To resolve this, simply place the column name in square brackets e.g.

select * from Sectors where [Key] = 'bagder'

For in more complex examples:

select Email, Name from People P inner join Sectors S ON J.Sectorkey = S.[Key];