SQL Prompt should give suggestions to global temp tables. Was there something in particular feature wise that you wanted SQL Prompt to do with Global Temp Tables?
Sean Quigley | Product Support Engineer | Redgate Software
The query would not work because the data is different The only thing that I can say is that the I am using a dynamic query to fill the global temp table as illustrated in my code snippet. Perhaps that is why it is not displaying the fields properly??
Good Morning! I tried working on this with my team to replicate this, but we weren't successful. If I remove the table name from INSERT INTO, and then try to let Prompt to suggest it, I don't get anything.
another example, Prompt doesn't suggest the table after FROM either
Can you send a more detailed step by step procedure on how you created the global temp table using the dynamic query and then how you attempted to have SQL Prompt work with it in order to help with the replication?
Sean Quigley | Product Support Engineer | Redgate Software
The step by step procedure on how the global temp table is the code I sent I did not create the table ahead of time - I am just running a select statement and insert into the global temp table. I just want SQL PRompt to be able to display the columns in that table as it is a pain to manually have to type them in the code
The team and I were able to look further into it and can confirm that as of this current time this isn't something that SQL Prompt can do.
The problem here is that the table is created in a dynamic SQL Query, so
SQL Prompt doesn't know anything about it. SQL Prompt needs to see the creation code in the query before it will
do this.
However, we don't parse the dynamic SQL or format it. Apologies for the inconvenience that this brings. If you would like for this to become a feature, I would highly recommend creating a uservoice request so that the developers can see the demand for such a feature.
Answers
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
The only thing that I can say is that the I am using a dynamic query to fill the global temp table as illustrated in my code snippet.
Perhaps that is why it is not displaying the fields properly??
I tried working on this with my team to replicate this, but we weren't successful.
If I remove the table name from INSERT INTO, and then try to let Prompt to suggest it, I don't get anything.
another example, Prompt doesn't suggest the table after FROM either
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
I did not create the table ahead of time - I am just running a select statement and insert into the global temp table.
I just want SQL PRompt to be able to display the columns in that table as it is a pain to manually have to type them in the code
However, we don't parse the dynamic SQL or format it. Apologies for the inconvenience that this brings. If you would like for this to become a feature, I would highly recommend creating a uservoice request so that the developers can see the demand for such a feature.
Thanks!
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?