Forum Replies Created

Viewing 15 posts - 16 through 30 (of 326 total)

  • RE: Sum and Count

    bitbucket-25253 (4/17/2013)

    Nice question ... Again thanks

    +1

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 18, 2013 at 2:28 am

    #1607584

  • RE: Row Constructor

    good one ...

    thanks for the question

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 17, 2013 at 12:52 am

    #1607133

  • RE: SQL JOINS

    I don't see any trick ; easy one ...

    adding join on duplicate values, make it like a cross product, get plenty of duplicate rows , add filter and...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 15, 2013 at 10:40 pm

    #1606677

  • RE: DateTime data types

    jlennartz (4/11/2013)

    If default values are returned as in your explaination why are not all the values except null returned in this format, "1900-01-01 00:00:00.0000000". How did they...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 11, 2013 at 11:32 pm

    #1605858

  • RE: DateTime data types

    Primo Dang (4/11/2013)

    Got it right by elimination

    Thanks, Sasidhar Pulivarthi! 😀

    +1

    Thanks for the question ..

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 11, 2013 at 11:23 pm

    #1605856

  • RE: How to find common tables between two databases?

    Lowell (4/10/2013)

    here's a really easy example:

    --common tables between the two

    SELECT name from SandBox.sys.tables

    INTERSECT

    SELECT name from Dictionary.sys.tables

    --tables only in SandBox

    SELECT name from SandBox.sys.tables

    EXCEPT

    SELECT name from Dictionary.sys.tables

    --tables only in Dictionary

    SELECT name from...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 10, 2013 at 10:04 am

    #1605319

  • RE: How to find common tables between two databases?

    sqlpanther (4/10/2013)

    Hello All,

    Can someone tell me how can we find common tables between 2 databases? Any scripts or querry plzz.

    thanks in advance...

    common table , by name , by attributes or...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 10, 2013 at 2:51 am

    #1605132

  • RE: Truncate Table

    nice and straightforwad - instinct worked for me ..:w00t:;-)

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 9, 2013 at 12:55 am

    #1604686

  • RE: Assigning values to Variables with CASE

    The case statement will assign 'FF' to @str6 ,Remaining varaibles contains NULL values by default and not assigned with corresponding values of AA,BB,CC,DD and EE. The values are assigned...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    April 3, 2013 at 3:41 am

    #1603072

  • RE: CASCADE - 1

    db4breakfast (3/21/2013)

    To be clear, we don't allow users to delete any record in our application. However there's a function for users to flag a record as error. Instead of cascade...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 21, 2013 at 7:00 am

    #1599358

  • RE: Delete v Truncate

    call.copse (3/21/2013)

    Raghavendra Mudugal (3/21/2013)

    ...

    - in general practice, as truncate removes all the records and no one wants to remove all the records from the table, only if any exceptional case...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 21, 2013 at 5:08 am

    #1599319

  • RE: CASCADE - 1

    One possible reason is that you can't control the order of locks being taken with cascading deletes and cascading updates. That makes it harder to avoid deadlock scenarios if you...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 21, 2013 at 5:05 am

    #1599317

  • RE: CASCADE - 1

    Hugo Kornelis (3/21/2013)

    Toreador (3/21/2013)

    Using cascade delete. If the business rule says that is the appropriate behaviour, then why avoid using inbuilt functionality that achieves exactly what you need?

    One possible reason...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 21, 2013 at 5:02 am

    #1599316

  • RE: CASCADE - 1

    Dineshbabu (3/20/2013)

    Lokesh Vij (3/20/2013)

    db4breakfast (3/20/2013)

    I never use cascade delete on a production db. It seem to be safer by allowing users mark order as "error" instead.

    +1

    same here. i feel it...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 21, 2013 at 2:01 am

    #1599243

  • RE: Delete v Truncate

    "It" refers to Truncate .

    It's a DDL , Data definition language - why ? I think because It resets the identity, that is a database object property change. [because, it...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    March 20, 2013 at 10:23 pm

    #1599214

Viewing 15 posts - 16 through 30 (of 326 total)