3 Kicks

SQL Server 2005 temporary tables bug, feature or expected behavior? (weblogs.sqlteam.com)

submitted by spirit1spirit1(3160) 3 years, 9 months ago

Some unexpected SQL Server behaviour around temporary tables that is good to know about. If it can be explained...

1 comment |category: |Views: 17

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
kprernnkprernn(1445) - rassirassi(0) - spirit1spirit1(3160)
Comments:

posted by BrianSuBrianSu(0) 3 years, 9 months ago 0

Hi Mladen,

This is a good example for us to see the usage of GO and temp table. Within one batch, we can't use into to create the same temp table twice. That's why the SQL engine (not sure exact name but kind of) quickly found this syntax error and complained.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?