Today’s day in SQL, volume III

I feel so dense.

Since Beta 2, I have been working with SQL Server 2005. As soon as the darned thing came out, I put it in production. I have lived with it and loved it, warts and all, for over a year.

And only today do I discover that it supports this

  Declare @T Table(I Integer)

  Execute SomeProcWithFittingResults
  Into @T

Previously, actual temporary tables were required. With the explicit hit on tempdb that it took.

What a terrible, terrible shock. I was crushed to find out I did not know everything there was to know. Good thing I do now.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: