問題文
A weekly report truncates each date to the start of its week and the buckets begin on a different weekday on two servers. The statement is identical on both. Which cause fits and which change makes it stable?
選択肢
- The starting day of the week comes from a language setting so setting the date language of the session makes the buckets stable across the two servers.
- A character value of zero length is rejected by the column so the load must have failed and those rows never reached the table.
- The starting day of the week comes from a territory setting so using the format element that follows the international standard makes the buckets stable.
- The starting day of the week comes from the first row that the query reads so ordering the rows before the truncation makes the buckets stable.