Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:47:36
|
Mangal writes "Sir,
Can we create Temporary Tables using Stored Procedures? If yes, then could you direct me as to how it is to be done. I tried creating a stored procedure as simple as :
CREATE PROCEDURE sp_temp_proc
AS
BEGIN
CREATE TABLE #temtable(emp INT, dept VARCHAR(20))
END
Although, the execution of the procedure says that command executed successfully, it does not create the Temporary Table mentioned at all. Could you please help? Your help is most wanted. Thanking you in anticipation and looking forward to an early response.
Your's truly,
Mangal." |
|
|
|
|
|
Can we create Temporary Tables using Stored Procedures???