I recently came across a situation where we need to create a json and save the result in a file. We were using SQL server 2017. We have created json...

I have recently used this feature and it was awesome. The only problem I have encountered to save the json data in file.
The output of json was large and...

Hi,

I am still unable to get your error... But, I think below link will help you for sure:

https://msdn.microsoft.com/en-us/library/ms188439.aspx

Please read "Keep identity".

Hi bitbucket-25253,

The question says "How many rows returned by executing all of the following?" and there is only insert statement,

the rows would be returned only when we select from @tbl.

If...

I am agree with the first statement but the second statement "SQL Server does not have an efficient way to retrieve rows based on a known value for PersonID." confusing...

Me also could not find the .dtsx file, but I make it by my own after viewing the screen shots with this article. Really nice article.

This question is quite wrong. The SET key word can not be used by = (EqualTo operator). The correct syntax is:

SET ANSI_NULLS OFF

this is wrong:

SET ANSI_NULLS= OFF

I am not getting the second option to change UNION to UNION all