What is difference between stored procedure and function?
Answer Posted / g.ashok
Stored Procedure need not to return a value.
Function should return a value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Describe in brief sql server monitoring ways.
What is the difference between upgrade and migration in sql server?
How do I find the sql server instance name?
How do we synchronize On-Premise SQL server with SQL Azure?
Can we use trigger new in before insert?
Is the primary key column of a table an index in ms sql server?
How to deploy the Report?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are different replication agents and what's their purpose? : sql server replication
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is an indexing technique?
What are “phantom rows”?
How sql server enhances scalability of the database system?
What is Dependency Injection and provide example?
Can group functions be mixed with non-group selection fields in ms sql server?