temp tables with UDF defaults

how do you get a temp table to use a udf in your db? I tried putting the databasename in front of dbo but it complained
about it. Does the function need to be created in tempdb too?


Create function mydate()
returns datetime
as
begin
declare @d datetime;
SET @d = getdate();
return @d;
end;

CREATE Table #t2
(
d Datetime NOT NULL DEFAULT (CONVERT(CHAR(, dbo.mydate(), 112))
)

Dan
You will need to process with a 'key-process' permanent table which has a
column as @@SPID to identify the session

If I remember well , Erland has a great article for the subject. Lookup his
website


"Dan Holmes" wrote in message

> how do you get a temp table to use a udf in your db? I tried putting the
> databasename in front of dbo but it complained about it. Does the
> function need to be created in tempdb too?
>
>
> Create function mydate()
> returns datetime
> as
> begin
> declare @d datetime;
> SET @d = getdate();
> return @d;
> end;
>
> CREATE Table #t2
> (
> d Datetime NOT NULL DEFAULT (CONVERT(CHAR(, dbo.mydate(), 112))
> )