Please check out the below link. I think it may be useful: http://newtec

What is the difference between Userdefined function and
stored procedure? Explain and give the example also

Question Posted / ashish

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

Please Help Members By Posting Answers For Below Questions

What is executereader?

943

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1000

Can a table have 2 primary keys?

977

Explain candidate key, alternate key, and composite key?

991

Write a code to select distinct records without using the DISTINCT keyword.

1107

What happens if you insert a duplicate key for the primary key column in ms sql server?

971

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

936

Does windows server 2016 come with sql server?

925

How to generate create function script on an existing function?

1108

How to update a field in SQL after ALTERING a row?

1229

Explain how dts is used to extract, transform and consolidate data?

987

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

898

What happens if null values are involved in arithmetic operations?

1004

Explain about unique identifier data type in sql server?

905

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1139