Viewing 15 posts - 2,806 through 2,820 (of 26,490 total)
Yes, if the target table existed in multiple schemas then you would have multiple column names returned in the cursor. I all the tables in the multiple schemas were identical,...
July 6, 2017 at 11:50 am
Just took a look at the query plan. The degree of parallelism is 10, 411 parallel operations, 70 sort operations, 22 hash match operations, 47 clustered index scans, 23 index...
July 6, 2017 at 11:27 am
Not sure if there is an actual standard, but the way I like to work it is like this. The join criteria between tables belong in the FROM clause and...
July 6, 2017 at 11:07 am
FizzBuzz is an interesting programming problem, and just for kicks I posted...
July 6, 2017 at 9:02 am
Are you ready...
June 30, 2017 at 4:34 pm
June 30, 2017 at 10:51 am
June 30, 2017 at 10:49 am
June 29, 2017 at 2:33 pm
June 29, 2017 at 1:29 pm
June 29, 2017 at 1:18 pm
June 29, 2017 at 12:24 pm
June 29, 2017 at 9:31 am
June 23, 2017 at 1:12 pm
Viewing 15 posts - 2,806 through 2,820 (of 26,490 total)