Forum Replies Created

Viewing 15 posts - 7,456 through 7,470 (of 39,902 total)

  • RE: The Pressure to Compromise Ethics

    Iwas Bornready (11/30/2016)


    My dad was a used care salesman (an honest one).

    Does it really matter how the code is written as long as the finished product functions in a way...

  • RE: The Pressure to Compromise Ethics

    jasona.work (11/30/2016)


    The problem with covering such situations, or trying to enforce "ethical" behavior by laws is, people will ALWAYS find ways to skirt those laws without breaking them. So,...

  • RE: The Pressure to Compromise Ethics

    roger.plowman (11/30/2016)


    This is a VERY tricky subject.

    First, because ethics are subjective. They are *concepts* and as our deplorably litigious society proves, ethics are fluid and mean exactly what the...

  • RE: The Pressure to Compromise Ethics

    Pascal J v Vuuren (11/30/2016)


    Major changes always goes to those living documents first before we even touch the code and whenever we build new features this is our starting point...

  • RE: The Pressure to Compromise Ethics

    David.Poole (11/30/2016)


    What I'd like to see is a framework to support whistle blowers.

    By all means insist on evidence but whistle blowers need protection. Most companies have a whistle blower...

  • RE: Finally, Create or Alter

    Jeff Moden (11/29/2016)


    Heh... yeeaaahhh... that's what I want to do for a 140 column table. 😉

    If you're treating code like code, then you'd always have the definition of the table....

  • RE: Finally, Create or Alter

    ZZartin (11/29/2016)


    What about cases where you don't necessarily want to sync up the tables exactly, there's advantages to having a simple make tables match kind of command but unlike stored...

  • RE: Finally, Create or Alter

    Nelson Petersen (11/29/2016)


    No need to specify all the columns when you only want to change one of them:

    create table test9 (c1 number, c2 number, c3 varchar2(26), c4 varchar2(14) );

    Table created.

    alter...

  • RE: Finally, Create or Alter

    t.franz (11/29/2016)


    @steve-2: What would you do regarding the column order, when you are facing a CREATE OR ALTER <table> statement and the column order differs from the real. Recreating could...

  • RE: Finally, Create or Alter

    djackson 22568 (11/29/2016)


    I never have an issue with this. A simple "if exists" tells me if I need to delete something before running create.

    Not for tables.

  • RE: Finally, Create or Alter

    t.franz (11/29/2016)


    I doubt, that an ALTER OR CREATE <table> would be used commonly, particularly since a CREATE table will usually need some indexes, FKs, CHECK CONSTRAINTs and some other stuff...

  • RE: Finally, Create or Alter

    henrik staun poulsen (11/29/2016)


    Steve,

    I'm perfectly happy about the enhancement that we got with

    DROP TABLE IF EXISTS myTable

    CREATE TABLE myTable(...)

    This ensures that the table is dropped, so that my Create table...

  • RE: Finally, Create or Alter

    hakim.ali (11/29/2016)


    IMHO, even "CREATE or ALTER objectname" can/should be reduced to just "CREATE objectname". Visual Studio database projects / SSDT has had this for years. Just issue the create statement,...

  • RE: Fantasy Football 2016

    Indeed

  • RE: Online T-SQL Scripts and Copyright

    robert.sterbal 56890 (11/28/2016)


    Steve Jones - SSC Editor (11/28/2016)


    Robert.Sterbal (11/9/2012)


    What is the current policy on this site?

    http://www.sqlservercentral.com/About/Terms

    It would be helpful to have a forum item to discuss the terms. Does one...

Viewing 15 posts - 7,456 through 7,470 (of 39,902 total)