Skip To Main Content
c.Postal Code on Muck Rack

c.Postal Code

As seen in: SQL Server Central
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

Get in touch with c.Postal

Contact c.Postal, search articles and posts on X, monitor coverage, and track replies from one place.

Learn more about Muck Rack

Actions

Share this page

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

Articles

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update) – SQLServerCentral

|
By c.Contact Name, c.Contact Title, c.Postal Code, o.Order Date
| SQL Server Central
(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.
Open in Who Shared Issue with article?

The Zero to N Parameter Problem – SQLServerCentral

|
By Sloan Holliday, c.Contact Name, c.Contact Title, c.Postal Code
| SQL Server Central
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.
Open in Who Shared Issue with article?
See all 2 articles