set @Year = Year(getdate())
set @Month = Month(getdate())
set @Day = Day(getdate())
set @NewBatchCode =Cast( @Year * 10000 + @Month * 100 + @Day as varchar(16))批号管理
set @Month = Month(getdate())
set @Day = Day(getdate())
set @NewBatchCode =Cast( @Year * 10000 + @Month * 100 + @Day as varchar(16))批号管理
declare @year int
declare @month int
declare @day int
declare @newBatchcode varchar(16) set @Year = Year(getdate())
set @Month = Month(getdate())
set @Day = Day(getdate())
set @NewBatchCode =Cast( @Year * 10000 + @Month * 100 + @Day as varchar(16))
select @newbatchcode
/*
(沒有資料行名稱)
20090209
*/