Forum Replies Created

Viewing 15 posts - 31 through 45 (of 146 total)

  • RE: Update many tables without hardcoding the table name

    ireshasun (3/26/2008)

    I want to update over 700 tables. I don't know how to write a SQL query to update tables without hardcoding the table name.

    Can anyone help me.

    Hi. In...

    April 7, 2008 at 7:50 am

    #799134

  • RE: Native Client error connecting with SQLCMD

    :blush: OK, I'll freely admit that I'm an idiot. It turns out that the SQL Network Interfaces line told the entire story. The command literally couldn't find...

    February 27, 2008 at 8:44 am

    #782567

  • RE: Thoughts on Andy Warren's Article 'Management'

    Loner (2/25/2008)

    DonaldW, I read the article from SELF magazine about woman having trouble to let go of bad manager experience.

    A few years ago, I landed a job and this was...

    February 26, 2008 at 6:17 am

    #781949

  • RE: Thoughts on Andy Warren's Article 'Management'

    Loner (2/24/2008)

    Andy Warren wrote an article about management. It is the career move for many senior DBAs and SQL developers. In most cases, many companies promoted senior programmers...

    February 25, 2008 at 9:47 am

    #781636

  • RE: Favorite Book Quote

    EdVassie (2/22/2008)

    My favourite quote from a technical book is from Graeme Birchall in the DB2 SQL Cookbook. This is a free resource, and contains much good advice on using...

    February 22, 2008 at 4:38 am

    #781041

  • RE: Favorite Book Quote

    Brandie Tarvin (2/21/2008)

    I'm glad I started this thread. I've been enjoying everyone's quotes. @=)

    It IS fun not only to see what people are reading but to get an idea...

    February 21, 2008 at 11:40 am

    #780809

  • RE: Favorite Book Quote

    Steve Jones - Editor (2/13/2008)

    Never read Monk. Come to think of it, I'm not sure there are any great quotations from books that strike me.

    In one of Janet Evanovich's novels...

    February 20, 2008 at 7:52 am

    #780207

  • RE: The Burden of Proof

    Adrian Nichols (2/8/2008)

    If companies are too worried about their code being opened up to the public perhaps, in legal cases, the code can be disclosed to the Expert Witnesses on...

    February 8, 2008 at 5:59 am

    #776358

  • RE: I am so depressed after I work on Question of the Day

    Brandie Tarvin (2/4/2008)

    One thing for sure. For those of us who go looking for the answer before we click anything, the QoD sure can hone a person's research skills....

    February 6, 2008 at 7:26 am

    #775576

  • RE: How to pass multi-row table data into stored proc

    Tom Leykis (2/4/2008)

    This is how I've always done it in the past:

    while @count < 10

    begin

    select @count = @count + 1

    ...

    February 5, 2008 at 12:47 pm

    #775302

  • RE: The January Car Update

    My tractor gets better mileage that many cars. I'm considering driving it to work every day. Parking at home would be problematic but in parking lots I'd win...

    January 31, 2008 at 6:39 am

    #773711

  • RE: Like Operator.

    GilaMonster (1/30/2008)

    Probably because you cleared the cache. I tend to prime the cache before running tests (run the query once so that I know the required results are in the...

    January 30, 2008 at 11:44 am

    #773446

  • RE: Like Operator.

    GilaMonster (12/20/2007)

    I'll try it out in 2005, see if the results are different.

    Just for the heck of it I tried the following against a table with ~800000 rows and a...

    January 30, 2008 at 7:58 am

    #773301

  • RE: Visual Studio Team Edition for Database Professionas question

    Grant Fritchey (1/30/2008)

    DonaldW (1/30/2008)

    At the last PASS Summit Gert Drapers said that they are going to try to get a data dictionary feature into the next release of Power Tools.

    That...

    January 30, 2008 at 7:01 am

    #773262

  • RE: How can I catch a blank column value on SP input?

    sg2000 (1/29/2008)

    Thanks jeremy for the suggestion. Following your suggestion, I used

    IF (@Name IS NULL OR @Name = '')

    and found it working well.

    sg2000

    If you want to add a further...

    January 30, 2008 at 6:56 am

    #773256

Viewing 15 posts - 31 through 45 (of 146 total)