SQL Server: what can a stored procedure do that a user defined function cannot? -


Can you please tell me that when there is a UDF then what is the need for stored functionality?

Closed above my head, a stored procedure can do the following tasks, which UDF can not do: < / P>

1) Modify data

2) Set the results to a client

3) Do non-deterministic activity


Comments

Popular posts from this blog

asp.net mvc - Dynamically Generated Ajax.BeginForm -

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

c++ - QtQuick: QQmlApplicationEngine failed to load component qrc:/main.qml:23 Invalid attached object assignment -