can we use temproray tables in stored procedure which is having dynamic sql in it.

FranklinRemo

Rate me:

0.00/5 (No votes)

2 Jan 2013CPOL

1.8K

Hi Recently i tried to create one temp table before dynamic sql and i compiled the SP.when i tried to execute the SP it is giving the error like my temp table doen't existex:PROCEDURE [dbo].[Proc_test]asbeginDECLARE @sqlstring NVARCHAR(4000)select * into #test from xtableSET...

Revisions

Compare	Revision	Minor	Date	Status	Editor
	2 - publicly available	No	2-Jan-13 3:06	Available	__TR__
Updates in content. 1 changes had been made.
	1	No	2-Jan-13 2:59	Available	FranklinRemo

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

FranklinRemo

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

can we use temproray tables in stored procedure which is having dynamic sql in it.

Revisions

License

Comments and Discussions