Why DML operations are not supported in functions

Hi Pankaj,

 

Functions have Only READ-ONLY database access. If DML operations would be allowed in functions, then functions would be pretty similar to stored procedures. 

 

http://www.sambhashanam.com/can-i-write-dml-statements-in-sql-server-functions/