Re: Computed columns in temp tables
From: Steven Yampolsky (syampolsky_at_eagleinvsys.com)
Date: 06/28/04
- Next message: Roji. P. Thomas: "Re: Computed columns in temp tables"
- Previous message: skfunx_at_yahoo.com: "Re: defragging SQL Database files"
- In reply to: Jacco Schalkwijk: "Re: Computed columns in temp tables"
- Next in thread: Roji. P. Thomas: "Re: Computed columns in temp tables"
- Reply: Roji. P. Thomas: "Re: Computed columns in temp tables"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 28 Jun 2004 10:27:13 -0400
How can I create a function in tempdb while inside a stored procedure? I
don't think I can do that.
Lets assume I can use sp_executesql to create the function inside a SP. What
will be a lifespan of it? Will it get dropped once the session is closed?
will it be accessible from other sessions? Will there be a name conflict
when two sessions will try and execute the same SP?
The more I get into it, the more questions I get. Hopefully I'll come out
with good knowledge! :)
Steve
"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote
in message news:uCXtqSrWEHA.2520@TK2MSFTNGP12.phx.gbl...
> As Vyas pointed out, the issue is that you have to create the function in
> tempdb. I think he is right in suggesting that you can't use UDFs that
> reside in a different database in the definition of a table.
>
- Next message: Roji. P. Thomas: "Re: Computed columns in temp tables"
- Previous message: skfunx_at_yahoo.com: "Re: defragging SQL Database files"
- In reply to: Jacco Schalkwijk: "Re: Computed columns in temp tables"
- Next in thread: Roji. P. Thomas: "Re: Computed columns in temp tables"
- Reply: Roji. P. Thomas: "Re: Computed columns in temp tables"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
