Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

MS-SQL @@DBTS

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

Dear Community,



it's solved. The command "Select @@DBTS" returns without a fieldname. "Select @@DBTS as LastRowVersion" works.

Geetings

View solution in original post

1 Reply
Highlighted
Not applicable

Dear Community,



it's solved. The command "Select @@DBTS" returns without a fieldname. "Select @@DBTS as LastRowVersion" works.

Geetings

View solution in original post