Geoff, Ginny,
One final question on the subject. If I use the UniqueIdentifier than
I have to specify the field (as also explained by Geoff) in my
application. No problem with this but when I specify a default Value
of NewID() in my application how should I than specify that field in
my UPDATE statement? If I specify nothing a "column name or number of
supplied values does not match table definition follow".
The other option, Integer Identify Column, seems not a Data Type I can
select from within SQL Express. At least.. I can not find that one.
Hope you can make this clear to me..
Thks, Rob


|