SQL Keyword Key - But also column name
Posted on 2012-03-12
I have a column named Key - but when trying to do this:
declare @userID varchar(15)
@userID = (SELECT Key from inserted)
I get an error as "Key" is a keyword, how do I get the info I want from the column and get around this issue with the keyword. As some further help this is the design of the table:
I am really new to SQL so any help would be great.