topic MS-SQL @@DBTS in QlikView https://community.qlik.com/t5/QlikView/MS-SQL-DBTS/m-p/153049#M30252 <HTML><HEAD></HEAD><BODY><P></P><P>Dear Community,</P><BR /><BR /> <P>it's solved. The command "Select @@DBTS" returns without a fieldname. "Select @@DBTS as LastRowVersion" works.</P><P>Geetings</P></BODY></HTML> Wed, 05 Jan 2011 16:49:26 GMT 2011-01-05T16:49:26Z MS-SQL @@DBTS https://community.qlik.com/t5/QlikView/MS-SQL-DBTS/m-p/153048#M30251 <HTML><HEAD></HEAD><BODY><P>Dear Community,</P><P>on MS-SQL-Server the TimeStamp is not realy a "Time Stamp". For further information watch this:</P><P><A href="http://msdn.microsoft.com/en-us/library/ms182776(v=SQL.90).aspx">http://msdn.microsoft.com/en-us/library/ms182776(v=SQL.90).aspx</A></P><P>For a clean incremental load, i want get the actual latest ROWVERSION from the SQL-Database using @@DBTS.</P><P>Is there an easy way to use this statement directly in the script ?</P><P>Thanks in advance for any help.</P><P>Christian</P><P></P></BODY></HTML> Tue, 04 Jan 2011 16:31:49 GMT https://community.qlik.com/t5/QlikView/MS-SQL-DBTS/m-p/153048#M30251 2011-01-04T16:31:49Z MS-SQL @@DBTS https://community.qlik.com/t5/QlikView/MS-SQL-DBTS/m-p/153049#M30252 <HTML><HEAD></HEAD><BODY><P></P><P>Dear Community,</P><BR /><BR /> <P>it's solved. The command "Select @@DBTS" returns without a fieldname. "Select @@DBTS as LastRowVersion" works.</P><P>Geetings</P></BODY></HTML> Wed, 05 Jan 2011 16:49:26 GMT https://community.qlik.com/t5/QlikView/MS-SQL-DBTS/m-p/153049#M30252 2011-01-05T16:49:26Z