CREATE function s_ConvertYearTermIDToTerm(@YearTermID char(5),@EntryYear char(4))
returns tinyint
as
begin
declare @Term tinyint
if( ISNUMERIC(@YearTermID) and ISNUMERIC(@EntryYear) )
set @Term= (Convert(int,@YearTermID)/10-Convert(int,@EntryYear))*2 + Convert(int,@YearTermID)%10
else
set @Term=0return (@Term)
end
说语法错误,小弟SQL刚入门,实在不明白哪里的问题。跪求大哥指点。
returns tinyint
as
begin
declare @Term tinyint
if( ISNUMERIC(@YearTermID) and ISNUMERIC(@EntryYear) )
set @Term= (Convert(int,@YearTermID)/10-Convert(int,@EntryYear))*2 + Convert(int,@YearTermID)%10
else
set @Term=0return (@Term)
end
说语法错误,小弟SQL刚入门,实在不明白哪里的问题。跪求大哥指点。
改為
if( ISNUMERIC(@YearTermID)=1 and ISNUMERIC(@EntryYear)=1 )