Viewing 10 posts - 1 through 10 (of 10 total)
I exchanged a couple of emails earlier this week with a very helpful lady called Melanie at SSC. They were already aware of a problem, and were working to...
November 22, 2013 at 8:31 am
Like2SQL - you may find that the exercises you are working with are designed for something like MS Access, where, I believe, the TEXT datatype is something different to SQL...
April 20, 2010 at 6:47 am
Hi Ryan,
One observation - it doesn't handle negative values.
This fixes that problem, but at the expense of some readability:
SELECT REPLACE(CONVERT(varchar(24), floor(abs(CONVERT(money, @S))) * sign(convert(money, @S)), 1),...
October 30, 2009 at 5:55 am
We still use 2000 here. We'll probably migrate to 2008 later this year - although rumours of a 2010 release for the next version make me wonder whether we...
March 6, 2009 at 3:30 am
I'm guessing the problem is that your ROWGUIDCOL isn't actually defined as unique in its own right. Your UNIQUE clause incorporates the PartKey column as well.
Try removing PartKey from...
March 3, 2009 at 4:58 am
Hi Ken,
Thanks, that was worth checking - but unfortunately we're using both Outlook 2003 & 2007, in Unicode mode. The strange thing is that if I send an email...
January 27, 2009 at 2:52 am
Hi Ken, thanks for the response.
I was pretty confident that I was passing the accented characters as Unicode, as they showed up as expected within sysmail_sentitems. And having looked...
January 26, 2009 at 3:10 am
Having just looked into this issue myself, I think it should be possible. In the example you give, I think all you are missing is the N in...
August 16, 2003 at 5:07 pm
Here's the explanation, which I found on the MS website...
Regardless of whether or not the second string is contained in the first string, if you pass NULL as any argument...
March 31, 2002 at 10:33 am
I'm not sure there are too many occasions where you'd deliberately use a null value in this way - it was a mistake in the code that brought the problem...
March 31, 2002 at 9:24 am
Viewing 10 posts - 1 through 10 (of 10 total)