What is the difference between Userdefined function and
stored procedure? Explain and give the example also
Answer Posted / anil sharma
Userdefined function can used in select statement.
It must return a values but in store procedure it is
optional.
Store procedure can use using sqlparameter but in
userdefined function it is not used.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is Transparent Data Encryption?
How you can get a list of all the table constraints in a database?
What is a covering index?
How to get a list all databases on the sql server?
how many bits ip address consist of? : Sql server database administration
Do you know how to send email from database?
What is a deadlock and what is a live lock?
What does the on delete cascade option do?
What is the user of Primary key?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Please explain what is “asynchronous” communication in sql server service broker?
How would we use distinct statement? What is its use?