Dear all,(sqlserver 2005)
i want to save the largest timestamp in a variable then
i want to get the changed and inserted record from a table
like select * from t where timestamp>@timestamp
is the above is correct ( basically i wanted timestamp to use in my stored proc which can
get me differential from database)
2) I could not under stand , how duplicate are getting created ,please tel me how it following is possible.(http://technet.microsoft.com/en-us/library/ms182776%28v=sql.90%29.aspx)
Duplicate timestamp values can be generated by using the SELECT INTO statement in which a timestamp column is in the SELECT list. We do not recommend using timestamp in this manner.