exec sp_executesql N'SELECT * FROM users WHERE id = @id', N'@id INT', @id=1
For anyone curious, here's an old article on the interface I'm talking about: http://www.techrepublic.com/article/shorten-development-time... Just so you don't think you have to memorize the above syntax.
I'm not sure what's used these days, but I assume it's fairly similar if not simplified a bit. If it's not broke right?
exec sp_executesql N'SELECT * FROM users WHERE id = @id', N'@id INT', @id=1