read from a temporary table

[tess1]

Hi,
How can I reed a value from a temporary table from within a function?

[hariharanmca]

Hi,
How can I reed a value from a temporary table from within a function?

Can you explain what you mean for temporary table?
Because for all tables same Query will acceptable.

[tess1]

Can you explain what you mean for temporary table?
Because for all tables same Query will acceptable.

I have this function :
CREATE FUNCTION [DBO].[f1]
( )
RETURNS BIT AS
BEGIN
SELECT c1 FROM #xTemp
END


#xTemp has creeted before execute this function f1 and I cannot creat it within the function

[hoomaniraji]

I have this function :
CREATE FUNCTION [DBO].[f1]
( )
RETURNS BIT AS
BEGIN
SELECT c1 FROM #xTemp
END


#xTemp has creeted before execute this function f1 and I cannot creat it within the function

i think if you use them in the same transaction.you have no problem.of course if you must use two transaction then set the 'transaction isolation level' to ''dirtyread".

[leela mn]

No you cant access the temporary tables in functions