Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: GO statement

    Oh, ok. Don't think I'll be needing that just yet haha.

    June 17, 2008 at 7:54 am

    #829783

  • RE: GO statement

    Thanks heaps for that. 🙂

    June 17, 2008 at 6:57 am

    #829731

  • RE: GO statement

    Hey thanks for that. Yeah I've read that on MSDN but I still didn't understand it. So I don't really have to use GO? It's not like transact sql or...

    June 17, 2008 at 6:40 am

    #829708

  • RE: LIKE keyword issues

    Mike John (6/17/2008)

    The expression you have will match true for ANY character that is NOT an e

    Something like ... NOT like '%e%' should do the job

    Cheers for that clarification. Haha...

    June 17, 2008 at 5:31 am

    #829682

  • RE: LIKE keyword issues

    How embarrassing... I posted too early! Haha. SELECT last_name

    FROM Employee

    WHERE last_name NOT LIKE '%e%';

    This is resolved. 😀

    June 17, 2008 at 5:27 am

    #829678

  • RE: Creating and Dropping a View

    Jeff Moden (5/19/2008)

    Mybowlcut (5/18/2008)

    Why do you need to do this? It may make a difference...

    What do you mean? It's part of an assignment. Please don't say this is a...

    May 19, 2008 at 5:24 am

    #817091

  • RE: Creating and Dropping a View

    Matt (5/17/2008)

    Try this, it should work. The only thing i have changed is ive added the 'GO' after each statement.

    -- Mitch Curtis

    -- A2view.sql

    -- Set the active database to KWEA.

    USE KWEA;

    GO

    --...

    May 18, 2008 at 7:29 pm

    #817062

  • RE: Foreign Key References Invalid Table

    Steve Jones - Editor (5/16/2008)

    The permissions might be that the tables aren't there. I was thinking you were dropping the table to add the FK. Typically you do an "IF...

    May 16, 2008 at 9:13 pm

    #816820

  • RE: Foreign Key References Invalid Table

    Yeah. I didn't get the table creation order right.

    Cheers.

    May 16, 2008 at 1:55 am

    #816297

  • RE: Foreign Key References Invalid Table

    Steve Jones - Editor (5/15/2008)

    Looks like rights, you can't drop those tables.

    Need to get an admin to give you rights.

    I don't know how that could be though, because I'm the...

    May 15, 2008 at 10:33 pm

    #816251

Viewing 10 posts - 1 through 10 (of 10 total)