Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 3,061 total)

  • RE: Delete record without using Delete keyword

    LutzM (10/20/2010)

    PaulB-TheOneAndOnly (10/19/2010)

    LutzM (10/16/2010)

    Before going any further I'd like to know the true reason why you don't use the simple DELETE statement.

    Well... imagine we are in the year 2030...

    October 20, 2010 at 2:11 pm

    #1239920

  • RE: Oracle Question

    Lynn Pettis (10/20/2010)

    For those watching this forum for Oracle questions, I have one here.

    Please check original thread

    October 20, 2010 at 12:48 pm

    #1239866

  • RE: Parallelism in Oracle

    Lynn Pettis (10/20/2010)

    Having an issue with a stored procedure that appears to be parallelism related.

    In stepping through the stored proc we were unable to get the procedure to create a...

    October 20, 2010 at 12:48 pm

    #1239864

  • RE: Cascading Deletes on a login table: FK integrity or audit accuracy?

    Simon D (10/20/2010)

    That's a terrific idea.

    It adds a bit of complexity, but it's also a layer of insulation against accidental deletes with cascading effects.

    Thanks very much for your input -...

    October 20, 2010 at 8:28 am

    #1239726

  • RE: Cascading Deletes on a login table: FK integrity or audit accuracy?

    Simon D (10/20/2010)

    A workaround would be to "disable" instead of "delete" WebAccountID

    I'm very intrigued by this option. How would I disable the WebAccountID in the WebLogin table? Can you provide...

    October 20, 2010 at 8:11 am

    #1239708

  • RE: Working with Oracle

    gints.plivna (10/20/2010)

    TOP also is SQL Server specific construction and not allowed in Oracle.

    Good catch.

    Poster also wants to replace "dbo" table prefix by whatever schema-name owns the affected tables.

    October 20, 2010 at 7:56 am

    #1239698

  • RE: Cascading Deletes on a login table: FK integrity or audit accuracy?

    Simon D (10/20/2010)

    I have a non-technical design question - something more along the lines of "what's everybody out there doing".

    I am in the process of building a database for a...

    October 20, 2010 at 7:52 am

    #1239694

  • RE: Recommended reading/books?

    Jo Pattyn (10/20/2010)

    I'm slowly updating my skills from 2000 to sql server 2008, mostly administration. (user, security, backup/restore)

    Do you have some reading/lecture/course?

    The easier way would be to check Microsoft KB...

    October 20, 2010 at 7:13 am

    #1239658

  • RE: Delete record without using Delete keyword

    LutzM (10/16/2010)

    Before going any further I'd like to know the true reason why you don't use the simple DELETE statement.

    Well... imagine we are in the year 2030 and Microsoft...

    October 19, 2010 at 7:56 pm

    #1239439

  • RE: What's next for SQL Server?

    A.J. Wilbur (10/19/2010)

    What's coming after SQL 2008 R2? Have I been working too hard and just not in the loop? Anybody got any news or rumors about what's...

    October 19, 2010 at 7:46 pm

    #1239438

  • RE: inserting rows

    SQLTestUser (10/19/2010)

    can you please direct me to where i can find an example

    Bing: PL/SQL BLOCK INSERT 🙂

    October 19, 2010 at 9:24 am

    #1239123

  • RE: Working with Oracle

    chakrapanishroff (10/19/2010)

    SELECT SalesProductKeyID,ActualUnitPrice,BillDateKeyID,ProductKeyID

    ,Qty,Profit,DD.dDate, (SELECT TOP 1 ISNULL(S.Qty,0) FROM dbo.Stock S , dbo.DateDimension DD1 WHERE S.DateKeyID = DD1.DateKeyID AND S.ProductKeyID = SF.ProductKeyID AND DD1.dDate <= DD.dDate

    ORDER BY...

    October 19, 2010 at 8:38 am

    #1239073

  • RE: inserting rows

    SQLTestUser (10/18/2010)

    can a simple block do it as well rather than a procedure ?

    Yes.

    October 19, 2010 at 6:15 am

    #1238979

  • RE: Learning Oracle

    WayneS (10/16/2010)

    Lynn Pettis (10/15/2010)

    PaulB-TheOneAndOnly (10/15/2010)

    nick.mcdermaid (10/14/2010)

    I'm impressed with Oracle packages as they almost seem like classes to me

    -Variables which 'reflect' existing table meta data

    -Custom data types

    -Multiple 'methods' within the package...

    October 18, 2010 at 5:26 pm

    #1238786

  • RE: Oracle empty string ('') is the same as NULL

    BowieRules! (10/18/2010)

    Where is CHAR datatype? 🙂

    Okay... this is going too far.

    Would you agree RDBMS engine is the one who runs the show?

    SQL> create table test(col1 char(10) not null);

    Table created.

    SQL> insert...

    October 18, 2010 at 12:42 pm

    #1238654

Viewing 15 posts - 1,381 through 1,395 (of 3,061 total)