Invalid use of a side-effecting operator 'INSERT' within a function.
  • i am creating sql function and want to insert data into table from sql function but when i use insert statement so i am getting error.

    Msg 443, Level 16, State 15, Procedure FiscalYearClosing, Line 70
    Invalid use of a side-effecting operator 'INSERT' within a function.

  • 1 Comment sorted by
  • Vote Up0Vote Down ithackerithacker
    117.50 Karma Accepted Answer
    you cannot perform database modification operation in function.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Tagged

Popular Posts of the Week

Optimum Creative