How can we help you today? How can we help you today?

# temp tables not showing up.

I have a few scripts that use # temp tables in order to hold intermediat data as it is massaged into the final form. I imagine that this is possibly caused by the #temp tables existing in tempdb with odd names instead of the active database so SqlPrompt does not know that they exist.

I have noticed that with table variables this works just fine and you get the suggestion lists but we have run into some performance issues using table variables and that isn't an option to just change them for that.

Travis DeAngelis
Sr. Software Engineer
AdvancedMD Software
ikatsu
0

Comments

1 comment

Sort by
  • Tilman
    Hi Travis,

    Thanks for the feedback. This is a known issue which fell by the way due to time constraints. We are planning to address this in a future version.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.