Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sreeju Usage of Functions in Stored Procedures RE: Usage of Functions in Stored Procedures

  • April 30, 2008 at 7:35 am

    #809029

    Confucius247 (4/30/2008)

    Mike C (4/29/2008)

    Table-Valued Functions.

    And if that were what we were talking about...

    My attitude with functions is avoid like the plague, as they break the rule of thinking in sets while programming SQL.

    I thought we were talking about SQL Server User-Defined Functions, which you "avoid like the plague" because they "break the rule of thinking in sets". Maybe it would help to add a little specificity to generalized blanket assertions about functions, since SQL Server actually supports 4 different types of User-Defined Function?