Viewing 15 posts - 16 through 30 (of 366 total)
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
April 12, 2017 at 12:33 am
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...
October 24, 2016 at 6:52 am
Excelent work, I was looking after such an exercise
thanks for sharing it.
Iulian
October 24, 2016 at 4:29 am
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...
October 17, 2016 at 9:23 am
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...
October 17, 2016 at 9:03 am
Iulian -207023 (10/17/2016)
Revenant (10/14/2016)
Steve Jones - SSC Editor (10/14/2016)
Iulian -207023 (10/13/2016)
The same way there is catalog...
October 17, 2016 at 8:52 am
Revenant (10/14/2016)
Steve Jones - SSC Editor (10/14/2016)
Iulian -207023 (10/13/2016)
The same way there is catalog for SSIS...
October 17, 2016 at 1:48 am
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...
October 13, 2016 at 11:57 pm
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; ...
September 26, 2016 at 12:44 am
TomThomson (8/2/2016)
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...
August 2, 2016 at 5:07 am
It looks OK when testing if the values are inserted:
...
SELECT * FROM #TableTest1
SELECT * FROM #TableTest2
August 2, 2016 at 2:30 am
Viewing 15 posts - 16 through 30 (of 366 total)