Difference between Function and Procedure-in general?
Answer Posted / rohan
function can be written in select statement but stored
procedure cannot be written in a select statement
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
Where is localdb stored?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why olap is used?
tell me the disaster recovery plan
Explain the different index configurations a table can have?
Difference between primary key and clustered index?
How to get a list of columns in a view using the "sp_columns" stored procedure?
List the different normalization forms?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is built-in/administrator?
What is similarity and difference between truncate and delete in sql?
What is partition in sql server?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is row_number function?
What are the advantages of having an index on the sql server?