Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
on MS-SQL-Server the TimeStamp is not realy a "Time Stamp". For further information watch this:
http://msdn.microsoft.com/en-us/library/ms182776(v=SQL.90).aspx
For a clean incremental load, i want get the actual latest ROWVERSION from the SQL-Database using @@DBTS.
Is there an easy way to use this statement directly in the script ?
Thanks in advance for any help.
Christian
Dear Community,
it's solved. The command "Select @@DBTS" returns without a fieldname. "Select @@DBTS as LastRowVersion" works.
Geetings
Dear Community,
it's solved. The command "Select @@DBTS" returns without a fieldname. "Select @@DBTS as LastRowVersion" works.
Geetings