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
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…