2
Simpler. Easier to read. Less prone to mistakes. Doesn't require permissions granted directly on the tables.
Though the two aren't equivalent. The WHERE clauses are different. Did you mean id = @id in the second?
Agreed, simpler is easier and better unless there is a reason to go complex.