Post reply

Side Effecting Operators in SQL

  • September 11, 2014 at 11:40 pm

    #397336

    Hello Experts

    I have tried to google this but couldn't find a satisfactory reply, so posting this question here.

    What are these side effecting operators in sql, I want to know why they are called so ?

    I know some operators like TRY Catch block is not allowed within function becoz it is a side effecting operator. So how we can say that an operator is side effecting operator.

  • September 12, 2014 at 1:22 am

    This was removed by the editor as SPAM

  • September 12, 2014 at 3:19 am

    #1745003

    Yes, exactly these are restricted operators within function.

    But what actually are they and how can we say an Insert/Update/TryCatch as Side effecting when used within function

  • September 12, 2014 at 4:46 am

    #1745024

    http://en.wikipedia.org/wiki/Side_effect_(computer_science)

    In computer science, a function or expression is said to have a side effect if, in addition to returning a value, it also modifies some state or has an observable interaction with calling functions or the outside world. For example, a function might modify a global variable or static variable, modify one of its arguments, raise an exception, write data to a display or file, read data, or call other side-effecting functions.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • September 12, 2014 at 4:59 am

    This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply