Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
(Note: We are re-running this as we had a newsletter issue last week) While this topic has been discussed before, here is another look at the "Multiple but Optional Parameters" issue in T-SQL. Sometimes you want to write a stored procedure which returns one or more Result(s), but you may or may not want to pass in some parameters. A comma delimited list just does not seem to cut it anymore, and dynamic SQL isn't a good idea.
Specifying 0 to N parameters for Stored Procedures with XML While the topic has been discussed before, here is another look at the "Multiple but Optional Parameters" issue, when using TSQL. Sometimes you want to write a stored procedure which returns ResultSet(s), but you may or may not want to pass in some parameters. A common delimited list just does not seem to cut it anymore. And dynamic sql doesn't cut the mustard either.
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
