Difference between Function and Stored Procedure?
Answer Posted / deepak
1)Functions cannot affect the state of the database which
means we cannot perform insert,delete,update and create
operations on the database.
Stored Procedures can affect the state of the database by
using insert,delete,update and create operations.
2)Functions are basically used to compute values
stored procedures are basically used to process the task.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are candidate key, alternate key and composite key? : Sql server database administration
What is the recommended total size of your memory optimized tables?
Explain difference between cross join and full outer join?
What is the difference between a function and a trigger?
What is side by side migration in sql server?
how to define testing of network layers? : Sql server database administration
What is the maximum number of index per table?
Why do we partition data?
How many triggers you can have on a table?
What is the difference between primary key and unique constraints?
What is 4nf in normalization form?
What is report snapshot in ssrs?
What is simple indexing method?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is difference between foreign key and unique key?