Is insertion order deterministic in a TABLE-valued function which instantiates the table and populates it with successive inserts, assuming no ORDER BY clause is used?
I needed to take a look at the ...
I need to split a comma delimited string, manipulate it, and then concatenate it back into a single string retaining the original order of the data (if possible).
For example, take a column definition ...
I am on SQL Server 2008 R2. I am executing the following SQL a
create table t1 ( c1 int, c2 int, c3 uniqueidentifier null)
insert t1(c1,c2) values (1,2),(1,3)
set c2 = ...
Given the following constants:
The same database with the same structure (tables, indexes, etc)
The same data
The same SQL Server and hardware configuration
The same statistics
The same SET options ...