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" |
|