what is the difference between procedure and function.
Answer Posted / saurav kumar
1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.
2) Stored proedure may or may not return a value but
function must return a value.
3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Define a cross join?
What is difference between primary key and foreign key?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is mean by candidate key?
List all the types of user-defined functions?
What is sql server profiler?
What functions can a view be used to performed?
What are built in functions?
What are the two authentication modes in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is meant by dirty read?
What is report snapshot in ssrs?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is SQL Azure Fabric?