Viewing 15 posts - 706 through 720 (of 11,678 total)
Easy one. A practice exam question was about the same behaviour. Once you've spent hours finding out why your answer isn't correct, you tend to never forget it again 😀
May 21, 2015 at 5:01 am
Confusing. I use segment elimination to indicate that a segment of rows has been eliminated, not necessarily an entire column.
But I guess that if you eliminate all segments of a...
May 21, 2015 at 3:45 am
Hugo Kornelis (5/15/2015)
SQL-DBA-01 (5/15/2015)
Seems like it's sort of ISNULL function. If it's encountered NULL, the 3rd parameter will replace the entered value. Nice Question.
No, the default parameter of LAG and...
May 21, 2015 at 3:32 am
GilaMonster (5/14/2015)
Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...
May 19, 2015 at 3:36 am
Joy Smith San (5/13/2015)
..Hope they will fix the issue and release it again asap.
It should be released by now:
https://www.microsoft.com/en-us/download/details.aspx?id=46694
May 19, 2015 at 3:32 am
preethi.kaliyamoorthy (5/13/2015)
Sorry if I am asking silly doubts. What is IsTransferred here. Is it a property for every table. I am just a beginner. I dont get it.
You asked yourself:
How...
May 13, 2015 at 4:28 am
preethi.kaliyamoorthy (5/13/2015)
May 13, 2015 at 4:10 am
preethi.kaliyamoorthy (5/13/2015)
Koen,I am sorry. I couldnt understand.
Can you please explain.
UPDATE s
SET IsTransferred = 1
FROM
myTable s
INNER JOIN
myStagingTable t
...
May 13, 2015 at 4:00 am
Gah, clicked the wrong one.
More caffeine!
Nice question though.
May 13, 2015 at 2:36 am
preethi.kaliyamoorthy (5/13/2015)
Is there any way of doing it without deleting the rows from the source table.
How to mark the rows as transferred instead of deleting it. I should not...
May 13, 2015 at 2:27 am
VRT (5/12/2015)
May 12, 2015 at 2:48 pm
VRT (5/12/2015)
May 12, 2015 at 2:18 pm
Viewing 15 posts - 706 through 720 (of 11,678 total)