I am using a function in the view for getting some result sets. In that function, based on some condition need to update rows to the database table.
Can anyone tell me, How can I do this
+1
A:
You cannot do this using SQL Server. SQL Server does not allow Update/Delete/Insert statements in UDFs. I think you are also prevented from calling a stored procedure as well.
Randy Minder
2010-01-19 12:46:03
Is there any work around for this?
Govindan
2010-01-19 13:53:06
@Govindan: not at all. Randy is 100% correct
gbn
2010-01-19 14:28:35
No work around. SQL Server does not allow functions to do Inserts/Updates/Deletes. You're going to have to do your data modifications within a stored procedure.
Randy Minder
2010-01-19 14:29:12
A:
SPs can read, write, delete, and update permanent tables.But you must be considerable if you wanna update rows in the base table (tables) of the view because there are some restrictions
Balend
2010-01-19 14:11:28
@Balend - You didn't read the question closely. He wants to update rows inside a UDF. This isn't allowed by SQL Server.
Randy Minder
2010-01-19 14:57:24