Unanswered: select query to retrieve value of primary key
I am struggling to retrieve the value of primary for a table. We are using MS SQL Server 2005. The database was designed years back by somebody else (he did n't follow the normalization rules at all). He used Key (which is a keyword in sql server) as the column name for primary key of a table. So I cannot use query like this : "select key from table_name hwere column2 = ? "
Could anyone help to write a query to get the value of the primary key for a specific row something like this : select primary_key from tbale_name where column2 = ?