|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
 Posted - 11/10/2006 : 08:19:10
|
vishwanath.G writes "Hi all
I have used UDF extensivily in my development environment, but still I would like to know wether the UDF is a compiled peace of code like Stored procedure are not?
I would like to know even I have used certain function as table valued functions for return columns
I have one question, which will perform by using the function or direct Sql statement for the columns
ex
dbo.fn_ITemDetails(ItemID)
ASSUME ITEMID = 10
select ItemName,MRP,UOM from dbo.fn_ITemDetails(10)
or
select ItemName,MRP,UOM from Ite Master where ITEMiD = 10
which one will perform better please let me know
thanks" |
|
difference between UDF and Stored procedure
