what is the difference between procedure and function.
- 4 Answers
- 7811 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / hitesh
1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What xml support does the sql server extend?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How many cores do I need for sql server 2016?
How many primary keys are possible in a table?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is transaction server explicit transaction?
Differentiate between truncate vs delete in mssql?
How do I get to sql server configuration manager?
What are the different types of replication you can set up in sql server?
Do you know what guidelines should be followed to help minimize deadlocks?
What is PROJECTION Operation?
What is the difference between left and right outer join?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Explain about Joins?
