HI SQLServerCentral Editor,

Please review the correct answer!!!

The correct answer should be 5.

Thanks.

Hi, I executed this code in SQL Server 2014 and 2008 R2, I got the message "Command(s) completed successfully."

Please check the correct reply.

Thanks, Regards.

I just confusing me when using the Trim function rather than thinking about the use of Derived Columns.

Thanks.

Hi,

Thanks for comment.

Thanks.

Thanks.

Thanks.

Hi Andy,

Good question, but in SQL Server SP1 2014 I managed to create the trigger and the file was inserted as normal.

I worked in SQL Server 2008 R2 and SQL Server 2012 and I ran this code and got the following error message:

Column 'MyBalances.AccountBalanceDate' is invalid in the select list because...

Hi,

My suggestion to reply to this question:

https://seniordba.wordpress.com/2015/06/04/disaster-recovery-what-is-rto-and-rpo/

Hi,

Good question!

This post helped me in reply

http://sqlwithmanoj.com/2015/06/15/temporal-data-support-in-sql-server-2016-part-1/

Ok.

Thanks.

Hi Ed,

Thanks for comment, I agree with you.

Hi Stewarts,

Thanks for comment.