Tag: SQL Server

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,…

By Manish Kumar December 23, 2015 0