Update database table in user Defined function RRS feed

  • Question

  • i am using sql 2005
    my requirement is, i want to use Update in user Defined function and that user defined function will be used in other Update query assigning value to a column.

    currently we are using scalar function but it is neither allowing update function in it nor couldcall any stored procedure that could on it part could update the database table.
    waht need to be done?

    web developer
    Wednesday, November 11, 2009 6:50 AM


  • You can't update a table in a user defined function.
    looking for a book on SQL Server replication? looking for a book on SQL Server 2008 Administration? looking for a book on SQL Server 2008 Full-Text Search?
    • Marked as answer by KJian_ Thursday, November 19, 2009 9:37 AM
    Thursday, November 12, 2009 3:54 PM