Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chetanb3
Yak Posting Veteran
52 Posts |
 Posted - 2008-07-01 : 06:18:18
|
| Can i use in,Out and INOUT parameter in function ? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-01 : 06:25:02
|
No
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-01 : 06:25:49
|
| UDF doesnt have ability to return values through output params.Why do you want out parameters in UDF? you can always use RETURN to return values you want. |
|
|
|
Kassem
Starting Member
7 Posts |
Posted - 2008-07-01 : 06:27:32
|
| if u mean by in , out the input and output variable for the function yes u cansee this Example Declare @VarOut nvarchar(10)Declare @VarIn nvarchar(10)Set @VarIn = 'Hi'Select @VarOut = Fns_GetVar(@VarIn)'* the function Fns_GetVar return the same input |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-01 : 06:56:55
|
quote:
Originally posted by Kassem
if u mean by in , out the input and output variable for the function yes u cansee this Example Declare @VarOut nvarchar(10)Declare @VarIn nvarchar(10)Set @VarIn = 'Hi'Select @VarOut = Fns_GetVar(@VarIn)'* the function Fns_GetVar return the same input
provided the function is scalar valued. |
|
|
|
|
|
|
In out parameter in function