You can use GETDATE() in a function?

Mattie

This really isn't helpful to Adam's question, but I can't believe no one commented on the fact that a database user/developer would be in the position of researching and recommending...

Hi Sam,

I used to use table variables (Declare @table) instead of temp tables all the time, primarily because they required less typing.  That is, until all the time I saved...

Hi David, thanks for responding.

There is a specific startup service account, it is not the system account.  (For those of you following along at home, be aware that to find...

David,

Thank you so much for responding, and I apologize in advance for the ignorance I'm about to display.  I don't know how to tell what account SQL Server is running...

You know, for as often as bitwise operator questions show up here, you'd think someone would define a real-world scenario of why it's helpful having this functionality

Is this your way of finding out how many people read your editorials?

Mattie

It is truly impressive how quickly Steve responds to reader input.  Add it to the list of why this is such an terrific site.

Thanks,

Mattie 

I don't know if this has been addressed in the many posts on this topic, but the topic of outsourcing raises an interesting question.  Are women leaving IT, or are...

My brother's programming group recently had an opening for an applications programmer who would be programming against an Informix database, using the Informix programming language.  The way the position was...

Rudy,

Thanks so much for your answer.  So if I understand you correctly, I can have QA on my machine to access any number of servers, as long as I have...

Does your license limit you to how many workstations can run Query Analyzer, as long as you don't install a database on those workstations?

Thanks,

Mattie

Not that I need a workaround for a problem I don't have in a database I don't have, but I was curious to see what kind of workaround was devised. ...

Steve,

Thanks.  As for my vote, my final answer is whatever's easier for you, because both of those work for me.  I suspect 'back to the way it was' will engender...

Steve,

Thanks.  I just finished reading the newsletter (online, it hasn't been delivered yet, I hope that's not related .  Yes, it made a big...