3 ms·
that would be: exec sp_executesql N'SELECT * FROM users WHERE id = @id', N'@id INT', @id=1
by pradocchia 15y ago
that would be:
exec sp_executesql N'SELECT * FROM users WHERE id = @id', N'@id INT', @id=1
- ssmoot 15y agoThanks 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-by-using-parameterized-queries-in-adonet/6093390 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?