Simple answer is No.
in fact when you try to issue a DML statement it complains:
Invalid use side-effecting operator Insert within a function
This is one of the limitation of SQL server function as defined in books online.
Functions are used to fetch data and stored procedures are ideally suited for all DML operations.
0 Comments.