siggemannen (1/28/2013)
Can SQL Server guarantee that if I issue a command like:
INSERT INTO T(...)
SELECT t.a, t.b, 1
FROM sometable t
UNION
SELECT -t.a, t.b, 1
FROM sometable t
, both "sides" of union will retrieve same table rows?
SQLserver will never guarantee the order if no specific order by statement is given.