Thứ Sáu, 30 tháng 9, 2016

T-SQL Cast datetime2 text to datetime

select cast(cast('2016-09-30 16:10:53.49876' as datetime2) as datetime)
-- result: 2016-09-30 16:10:53.500

Thứ Tư, 21 tháng 9, 2016

Compare 2 branches in TortoiseSVN

http://stackoverflow.com/questions/4675517/compare-files-between-two-branches-in-tortoisesvn

  1. Go to the repository browser (<right click>/TortoiseSVN/Repo-browser/<enter URL>).
  2. Open right click menu on branch B, select 'Mark for comparison'.
  3. Then open right click menu on branch A, select 'Compare URLs' or 'Show differences as unified diff'.