Viewing 15 posts - 53,146 through 53,160 (of 59,068 total)
george sibbald (1/3/2008)
Jim Russell (1/3/2008)
January 3, 2008 at 10:06 am
This is why it's such a bad idea to ever store date information in any type of Data-Type other than DATETIME...
January 3, 2008 at 12:18 am
Inputs are higly appreciable!
Ok... then study the article at the following URL before you post like this again...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
... then, do what it says 😉
January 3, 2008 at 12:09 am
Answer is a Tally table or a Calendar table. Also, see the following since you're a "newbie"....
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 3, 2008 at 12:00 am
January 2, 2008 at 11:58 pm
Checksum works great if you make sure not to include "non-comparable" columns such as Text, NText, Image, Cursor, and SQL_Varient. It won't tell you what changed, but it'll help...
January 2, 2008 at 11:51 pm
January 2, 2008 at 11:36 pm
After working for them for 4 years, I recently found out that my whole company is leaving Michigan and moving to North Carolina sometime later this year...
I resolve to...
January 2, 2008 at 11:30 pm
Sanjay Pandey (1/2/2008)
Sanjay Pandey (12/21/2007)
Using Datefunctions.select getdate()-day(getdate()) as LastDayLastMth, getdate()-(day(getdate())-1) as FirstDayThisMth,dateadd(m,1,getdate())-day(dateadd(m,1,getdate())) as LastDayThisMth,dateadd(m,1,getdate())-day(dateadd(m,1,getdate()))+1 as FirstDayNextMth
Friends, please analyse the above one also in comparision to datediff. I use it always...
January 2, 2008 at 11:03 pm
Shaun McGuile (1/2/2008)
Though to be fair in an interview I would not expect anyone to know the exact syntax required to address...
January 2, 2008 at 10:53 pm
Actually, I'm pretty much out of line here... I do everything from T-SQL... I've never written a DTS package and will probably never write an SSIS "package". My appologies...
......
January 2, 2008 at 9:38 pm
The real point here is that you should not be using any form of RBAR in a trigger... no matter how you do it, calling a RBAR proc from a...
January 2, 2008 at 9:34 pm
Sadly, no... no such luck.
About the only thing you could to is have the function return a special value and check that value in the calling code... if your code...
January 2, 2008 at 9:26 pm
For future reference, please see:
Forum Etiquette: How to post data/code on a forum to get the best help
http://www.sqlservercentral.com/articles/Best+Practices/61537/
This will show you how to build a test case for others to...
January 2, 2008 at 9:12 pm
Viewing 15 posts - 53,146 through 53,160 (of 59,068 total)