简单急诊

Question

在BBS中要命名一个编号 ：编号=版块编号_当前日期_四位随机数
INSERT BBSTopic (TNumber,TSID,TUID,TReplyCount,TEmotion,TTopic,TContents,
TTime,TClickCount,TFlag,TLastCLickT)  VALUES ('1_'+  Convert(VARCHAR(4),DATEPART(YYYY,GETDATE()))+Convent(varchar(2),DATEPART(MM,GETDATE()))+
Convent(varchar(2),DATEPART(DD,GETDATE()))+'_'+
Convent(varchar(4),RIGHT(DATEPART(MS,GETDATE())*1000,4)),2,3,50,66,
'我','暗暗啊','2005-7-12',200,1,'2005-7-20'
      提示错误 'varchar' 不是可以识别的 函数名。

Answer 1

INSERT BBSTopic (TNumber,TSID,TUID,TReplyCount,TEmotion,TTopic,TContents,
TTime,TClickCount,TFlag,TLastCLickT)VALUES ('1_'+Convert(VARCHAR(4),DATEPART(YYYY,GETDATE()))+Convert(varchar(2),DATEPART(MM,GETDATE()))+
Convert(varchar(2),DATEPART(DD,GETDATE()))+'_'+
Convert(varchar(4),RIGHT(DATEPART(MS,GETDATE())*1000,4)),2,3,50,66,
'我','暗暗啊','2005-7-12',200,1,'2005-7-20')--拼写错误,Convent 应该是Convert