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
How to create a large table with random data for index testing in ms sql server?
What is explicit mode in sql server?
What are the types of subscriptions in SQL Server replication?
What are different types of subquery?
How to filter out duplications in the returning rows in ms sql server?
What is save transaction and save point?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Explain the truncate command? : SQL Server Architecture
Define full outer join in sql server joins?
How can we migrate from SQL server to SQL Azure?
What is the difference between join and inner join?
Explain how to send email from sql database?
Explain various On-Delete options in a DB table. Which is the default option?
Define cursor locking
What is BCNF? How is it better than 2NF & 3NF?
