Forum Replies Created

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

  • RE: Stored procedure parameters

    I think the 2nd answer, it can accept output params only, should have been true too.
    Running on 2016 dev ed.

    CREATE PROCEDURE xyz(@po INT OUTPUT)
    AS

  • RE: EzAdo - Part 1

    Is there something else other than FOR JSON PATH a stopper to use it with previous versions of SQL Server ?

    If so then I would say that the _toJson...

  • RE: EzAdo - Part 1

    Excelent work, I was looking after such an exercise

    thanks for sharing it.

    Iulian

  • RE: The Attribute

    Jeff Moden (10/17/2016)


    Iulian -207023 (10/17/2016)


    Jeff Moden (10/17/2016)


    My answer would be "None of the above" because I don't want people to store XML in the database. 😉

    Well ... there is...

  • RE: The Attribute

    Jeff Moden (10/17/2016)


    My answer would be "None of the above" because I don't want people to store XML in the database. 😉

    Well ... there is also the case when...

  • RE: Executing an R Script

    Iulian -207023 (10/17/2016)


    Revenant (10/14/2016)


    Steve Jones - SSC Editor (10/14/2016)


    Iulian -207023 (10/13/2016)


    Nice one, but I thought there is a way to pass just the script's name.

    The same way there is catalog...

  • RE: Executing an R Script

    Revenant (10/14/2016)


    Steve Jones - SSC Editor (10/14/2016)


    Iulian -207023 (10/13/2016)


    Nice one, but I thought there is a way to pass just the script's name.

    The same way there is catalog for SSIS...

  • RE: Executing an R Script

    Nice one, but I thought there is a way to pass just the script's name.

    The same way there is catalog for SSIS and a reporting DB for SSRS, it would...

  • RE: The Attribute

    Nice one,

    I love text searching and parsing

    Ta

  • RE: Comparing with NULL

    Rune Bivrin (9/26/2016)


    Nice question, but the correct answer is as usual: "It depends". In this case on the setting of ANSI_NULLS.

    Good one! SET ANSI_NULLS ON / OFF; ...

  • RE: Comparing with NULL

    Nice one

    it's null's fault 🙂

  • RE: Starting an SSIS Package

    Nice one

    More on concurrency 🙂

    Ta

    Iulian

  • RE: Small rounding

    Yes, they shall fix this one.

    Nice spot,

    Iulian

  • RE: Temp Table Foreign Keys

    TomThomson (8/2/2016)


    Nice question.

    It indicates yet another piece of really sloppy human interface design on Microsoft's part. if Foreign Keys on temprorary tables are not enforced, allowing them to...

  • RE: Temp Table Foreign Keys

    It looks OK when testing if the values are inserted:

    ...

    SELECT * FROM #TableTest1

    SELECT * FROM #TableTest2

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