SQL SERVER MANAGEMENT STUDIO: Create Table in Stored Procedure and view in object brower
Posted on 2007-03-27
How do I create a table in a stored procedure and view it in management studio?
I've tried a create table command and a select into command. Both execute without errors. However the Object Explorer does not seem to register that a table exists in the selected database. What's the deal? When I create a table in a stored procedure where does it go? Is it a temporary table? How do I verify the table has been correctly populated?
Any help is appreciated,
CREATE TABLE CEA.DBO.RYAN_TEMP
CREATE TABLE CEA.DBO.CEA_TRANS
INSERT INTO RYAN_TEMP
WHERE policy_id = 96