Viewing 9 posts - 1 through 9 (of 9 total)
One more major diff.
You can not use temp tables in UDF
But can use table variables in UDF....
January 17, 2010 at 4:15 am
U can't do it without having a certain rule defined to the search criteria, if u want to do it through coding.
Like:-
White horse Company White horse...
October 27, 2009 at 7:56 am
No the insert statement wont execute....
It seems there is a problem with the insert statement (column mismatch)
If possible provide us the department table's structure....
March 19, 2009 at 12:58 am
You rock ALZDBA....
Its working like M16 ..........:cool:
Thanks dude!!!
March 9, 2009 at 2:07 am
Ya Adi
we can execute extended procs in UDF.
But anyhow i dont think we can make any such XP to execute dynamicn sql.
So mean to say that i have to...
January 28, 2009 at 9:08 am
Hi Adi
ur comments ,,,, if any?
Thanks
smeet
January 28, 2009 at 8:52 am
Hey Gail, Sandy
Suppose this is the case......... [See Below the example]
I would like to use this salary value returned from the function where ever it is required , right now...
January 28, 2009 at 8:49 am
Thanks guys.....
The salary example is not the real situation.
But yes we cant avoid dynamic sql as i'm taking the database instance name from another function.
like :-
select @val =...
January 28, 2009 at 8:22 am
Viewing 9 posts - 1 through 9 (of 9 total)