Create test
{
ID int Identity,
OrderID as Replace(convert(char(10),getdate(),120),'-','')+stuff(convert(nvarchar,(10000+ID),1,1,''))
}
Create test
{
ID int Identity,
OrderID as Replace(convert(char(10),getdate(),120),'-','')+stuff(convert(nvarchar,(10000+ID),1,1,''))
}