Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pradeep aryan
1. Function can returtn single value but proc san return
multiple values
2. Proc can call a function but function not.
3. function can call in select statement also and acn perform
action also but proc not.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a trigger? Why we need it?
Differentiate between truncate vs delete in mssql?
What is sqlcmd?
What is a fan-out query in SQL Azure?
What are the different types of backups avaialabe in sql server 2005?
What is the difference between a check constraint and a rule?
When is the use of update_statistics command?
How to use the inserted and deleted pseudo tables?
How do I know if localdb is running?
what is a self join? Explain it with an example? : Sql server database administration
How to select an exiting database using mssql_select_db()?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
If the job running very slow what is the action you do
What is the difference between dbcc indexdefrag and dbcc reindex?
Can a cursor be updated? If yes, how you can protect which columns are updated?
