I worked for MS Certified Partner. Do you think my company will get the beta2 version or I should download it by myself. If MS Certified Partner usually get a...

try this

DECLARE @YEAR CHAR(4), @MONTH VARCHAR(2), @DAY VARCHAR(2)

SET @YEAR = CAST(YEAR(GETDATE()) AS CHAR(4))

SET @MONTH = CAST(MONTH(GETDATE()) AS VARCHAR(2))

IF LEN(@MONTH) = 1 SET @MONTH = '0' + @MONTH

SET @DAY =...

When will Beta2 be released? I'm dying to wait

You can create a USER-DEFINED FUNCTION (UDF) to generate a complex ID, and then use that UDF on an AFTER INSERT TRIGGER for the table.If you don't need a complex...