You can use SQL's built-in DateTime functions to extract various date values such as Year() which will return the 4 digit year of a date.  In your case your date...

I apolagize for not having the complete code for this but I don't have much time this morning while my internet is still up and I'm trying to handle as...

No method of securing digital material will remain secure.  At some point all security technologies will be hacked period!  It is only a matter of when not if.  Because of...

Jamie, I'm not doubting what you are describing has happened to you but I find it odd that when I try to duplicate this I am unable to produce the...

I also come from a mixed background with experience in both programming (primarily in VB) and SQL (Specifically SQL Server 7 & 2000) and I see the CLR integration as...

My company produces accounting software for a specific industry.  Often our clients have multiple database's because the government or some other legal entity has one or more regulations requiring this...

Nothing in this world is free.  SQLServerCentral's method of dealing with advertising in the way it has is the best compromise I have ever seen.  If there are those who...

Brian,

   I can't find the words to thank you enough for the links to the motivational articles at dexterity.com .  The techniques provided in these articles will greatly help me...

Julian,

   Curiosity question. 

   It is my opinion, based on reading from numerous sources, that it is very important that the database be properly structured for optimal performance and that...

Journeyman,

You mentioned Query Analyzer in your story yet I do not believe that Yukon (SQL Server 2K5) includes QA or anything like it. Sure the workbench allows you to...

David,

     Your piece about the 3 types in an organization is some of the best stuff (for lack of a better word) that I have come across in a long...