Create table TestDatetime2(a Datetime2(6)) 

prepst#!# Insert into TestDatetime2 Values(@a) #!#Datetime2|-|a|-|2016-10-23 12:45:37.123|-|0
prepst#!#exec#!#Datetime2|-|a|-|2016-10-23 12:45:37.123|-|3
prepst#!#exec#!#Datetime2|-|a|-|2016-10-23 12:45:37.12|-|2
prepst#!#exec#!#Datetime2|-|a|-|2016-10-23 12:45:37.1|-|1
prepst#!#exec#!#Datetime2|-|a|-|2016-10-23 12:45:37.1234|-|4
prepst#!#exec#!#Datetime2|-|a|-|2016-10-23 12:45:37.123456|-|6
prepst#!#exec#!#Datetime2|-|a|-|2016-10-23 12:45:37.123456|-|5
#prepst#!#exec#!#Datetime2|-|a|-|12:45:37.123456|-|5
prepst#!#exec#!#Datetime2|-|a|-|<NULL>

select * from TestDatetime2

Drop table TestDatetime2