News for hackers. Stuff that matters.
Re:Stack Overflow Makes Slow Pages 100x Faster By Simple SQL... by pradocchia on Tuesday May 03, 2011 @01:48PM (#2510941)
that would be:

exec sp_executesql N'SELECT * FROM users WHERE id = @id', N'@id INT', @id=1

Re:Stack Overflow Makes Slow Pages 100x Faster By Simple SQL... by ssmoot on Tuesday May 03, 2011 @06:35PM (#2511920)
Thanks for the syntax help. It's been awhile. ;-)

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?