Answer Posted / sakthi
Inside function we cannot able to insert, udate or delete
any record but in procedure we can use it. inside function
we cannot able to call any other functions or procedure but
inside procedure we can call other procedure and functions.
these are the major differences
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain what is sql server english query?
What is the difference between a view and a stored procedure?
What do you mean by stored techniques? How would we use it?
What is ms sql server reporting services?
What are the differences between user defined functions and stored procedures?
What is logon trigger?
How to connect ms access to sql servers through odbc?
Explain can SSRS reports Cache results?
Explain what is meant by replication of database?
How to modify the underlying query of an existing view?
What is the difference between implicit and explicit transaction?
How does a profiler work?
How to create an index on an existing table in ms sql server?
How can you list all the columns in a database?
What are the High-Availability solutions in SQL Server and differentiate them briefly?