Lee Linares (5/23/2016)

---

You can also get erroneous output if the object_id of an object exists in more than 1 database. In my testing a stored procedure was reported as having...

Derek Slinn (9/1/2016)

---

I think the answer is wrong,

Both are stored in tempdb database.

technically table variables can just be in memory if there is only a small amount of data in...

Wow, got that one wrong. I thought the table variables were in memory. Learned something today.

So true. First of all I love stay-cations. I don't need to travel the world or even just the countryside to relax. Second, I often use of a week or...

In our shop we only use views to retrieve data, not update it.

As usual, I don't get it. I wish there would have been some Far Side computer jokes.

Good to know, thanks.

Good question, thanks.

It's amazing to me that even after years of programming for our company, some programmers still don't understand the data structure (though it is quite large). We write stored procedures....

Thanks for the education.

That's pretty cool, thanks.

You are fortunate to have a job that allows this kind of travel and meeting of so many people. Have a great time.

I learned something, thanks.

sknox (8/25/2016)

---

The correct answer is "it depends."

MOST of the time you'll get two rows as explained in the answer.

HOWEVER, each GETDATE() within each SELECT is evaluated separately. When the separate...

Same here.