function vs stored procedure in sqlserver 2000

[yazan_zahi]

when we use function ? when we use stored procedure ? how can i defin a function (syntax)? Witch better to use function or sp ? can you be fast pls ??? thank you ?

[SeMartens]

Hi, as far as I know, function returns a single value as result. Stored procedures are used to compute something without any direct result. For example filling a table with statistical data can be done perfectly with a sp. Functions are better when you want to compute a single value, for example the gross versus net sum. Hope this helps a bit, regards Sebastian P.S: For definition of a function use google, I think it will point you in the right direction.

[saqib82]

you can not execute a t-sql query in a function but in stored procedure you can.

[Sumitjh82]

functions return only one value.........sp can used to return more than one value.... function need to be complied each time u use....but sp ones complied u can use it...till if cant change any thing:)