Viewing 15 posts - 53,146 through 53,160 (of 59,064 total)
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
george sibbald (1/2/2008)
an object created by a sysadmin will always be owned by dbo...
January 2, 2008 at 9:07 pm
My personnel belief is that cursors are the tools invented by the evil....
Heh... HOT DAMN! A kindred spirit! 😀
January 2, 2008 at 9:01 pm
There is a third option that lot's of folks forget about... that is the one of a formula in the code instead of an extra join or a dip on...
January 2, 2008 at 8:59 pm
Aye... nicely done... glad to see you back in the swing of things.
Yep, I'm aware that ROW_NUMBER doesn't imply NOT NULL like IDENTITY does...
... but both Itzek's method and...
January 2, 2008 at 8:39 pm
Viewing 15 posts - 53,146 through 53,160 (of 59,064 total)