>>I've never seen an identity column NOT follow the appended sequence, but as you say, it can't be logically proven that it won't.
>>That said, I think JR's question also addresses the way a VFP remote view saves the data.
>>I've never used one. I've only used SPT.
>
>It's theoretically possible if it's not defined as a clustered index and PK.....but someone would have to do some real messing around with it.
>
>I know JR loves remote views and obviously others use them as well. I've only ever used stored procs and SPT, and now that Microsoft allows someone to pass an ADO.NET datatable (or even a list) to a stored proc as a parameter, I don't think I can ever see myself every writing a remote view. But obviously every person out there has a library that is years or even decades older.
PMFJI.
"Microsoft allows someone to pass an ADO.NET datatable"
1. Which SQL Server version/year has this feature?
2. Do you have a URL or can you post a simple example of how an ADO.NET datatable can be parsed in a stored procedure?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
