DML statements in SQL server functions
We can not write DML statements in SQL functions. Functions have Only READ-ONLY database access. If DML operations would be allowed in functions, then functions would be pretty similar to stored procedures. The way it is, a stored procedure can use a function, but not vice versa. Therefore, functions increase the “power” of stored procedures,…