Forum Replies Created

Viewing 15 posts - 106 through 120 (of 286 total)

  • RE: The BIT data type

    Thanks for the question.

    I did wonder if going beyond the bound of the int datatype would cause it to fall over, but no. You have to go far beyond that:

    DECLARE...

    March 29, 2011 at 1:57 am

    #1304713

  • RE: Data conversion

    rmechaber (3/28/2011)

    I had always used the ANSI syntax thinking it was multilanguage, only to discover later that it wasn't. The reason I'd never noticed is probably that almost all our...

    March 28, 2011 at 7:38 am

    #1304346

  • RE: Data conversion

    rmechaber (3/28/2011)

    I had always used the ANSI syntax thinking it was multilanguage, only to discover later that it wasn't. The reason I'd never noticed is probably that almost all our...

    March 28, 2011 at 7:29 am

    #1304337

  • RE: Data conversion

    rmechaber (3/28/2011)

    Thanks very much Duncan, that is what I suspected would result.

    Tom Thomson: it would be interesting if you still have access to those databases to poke around...

    March 28, 2011 at 6:57 am

    #1304321

  • RE: Data conversion

    rmechaber (3/28/2011)

    I'd still like to see someone try this out on a SQL 2000 box:

    SET LANGUAGE british

    SELECT CAST('2003-02-28' AS datetime)

    Similar error: "The conversion of a char data type to a...

    March 28, 2011 at 6:25 am

    #1304308

  • RE: Operators

    Donny-1012435 (3/28/2011)

    I have SQL 2008, but got the Incorrect Syntax near '=' error.

    Btw, I have both 2005 and 2008 on my PC.

    Perhaps your database is in 2005 compatibility mode? Or...

    March 28, 2011 at 3:51 am

    #1304245

  • RE: Operators

    Christian Buettner-167247 (3/28/2011)

    Tom.Thomson (3/27/2011)

    One comment though: depending on settings of ARITHABORT and ANSI WARNINGS, it is quite possible that none of the answer options will result, because the batch is...

    March 28, 2011 at 3:24 am

    #1304234

  • RE: Operators

    Nice question, thanks. Took me a while to work out what was being asked!

    March 28, 2011 at 1:30 am

    #1304197

  • RE: RAID 5 Parity

    Thanks for the question. Reading the article, I now understand RAID 2, 3 and 4 as well.

    But won't we all be using ZFS in a few years anyway? 😉

    March 25, 2011 at 3:40 am

    #1303440

  • RE: Operating system error 1450

    John.Liu (3/13/2011)

    Can you re-produce the problem with adjusting memory setting to it's original values? If you can re-produce it, it may be related to memory setting (but I don't know...

    March 24, 2011 at 9:34 am

    #1303063

  • RE: inline table valued function performance problem

    I've tried it out locally, and get about the same time for all of them (< 1s)

    The last 2 have identical query plans apart from the variable declaration and identical...

    March 24, 2011 at 9:29 am

    #1303058

  • RE: Trigger Question

    Paul_Harvey (3/24/2011)

    Oh that's brillant! And it works perfectly.

    Thanks very much for your help on this.

    🙂

    No problem, glad to help 🙂

    March 24, 2011 at 7:37 am

    #1302962

  • RE: Trigger Question

    Paul_Harvey (3/24/2011)

    I have made some attempts. The following does <more or less> what I need:

    ALTER TRIGGER [dbo].[trClearBounced]

    ON [dbo].[Contact]

    AFTER UPDATE

    AS

    IF ( UPDATE (Email) )

    BEGIN

    Update contact

    SET bounced = 0

    FROM...

    March 24, 2011 at 7:21 am

    #1302943

  • RE: Trigger Question

    Paul_Harvey (3/24/2011)

    Great. Thanks for the pointer. I'll try to get the trigger working now.

    Wish me luck!

    Luck's got nothing to do with it. Armed with BOL and these forums,...

    March 24, 2011 at 6:54 am

    #1302907

  • RE: Trigger Question

    You should be able to use an update trigger to do what you want. You'd use the IF UPDATE(<column_name>) syntax to only set the flag if the email column was...

    March 24, 2011 at 6:19 am

    #1302887

Viewing 15 posts - 106 through 120 (of 286 total)