Click here to Skip to main content
12,755,827 members (38,763 online)
Click here to Skip to main content

Tagged as

Stats

920 views
Posted 1 Jan 2013

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

, 2 Jan 2013 CPOL
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 1-Jan-13 23:06 Available __TR__
Updates in content. 1 changes had been made.
1 No 1-Jan-13 22:59 Available FranklinRemo

License

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

Share

About the Author

FranklinRemo
India India
No Biography provided

You may also be interested in...

Pro
Pro
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170217.1 | Last Updated 2 Jan 2013
Article Copyright 2013 by FranklinRemo
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid