What is the difference between Userdefined function and
stored procedure? Explain and give the example also
Answer Posted / ashish
Please check out the below link. I think it may be useful:
http://newtechnobuzzz.blogspot.in/2014/07/difference-between-user-defined-funtion.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is executereader?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Can a table have 2 primary keys?
Explain candidate key, alternate key, and composite key?
Write a code to select distinct records without using the DISTINCT keyword.
What happens if you insert a duplicate key for the primary key column in ms sql server?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Does windows server 2016 come with sql server?
How to generate create function script on an existing function?
How to update a field in SQL after ALTERING a row?
Explain how dts is used to extract, transform and consolidate data?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What happens if null values are involved in arithmetic operations?
Explain about unique identifier data type in sql server?
How display code or Text of Stored Procedure using Sql query in Sql Server ?