create function Ma_x(@str_id varchar(15))
returns varchar(15)
as
begin
declare @x varchar(15)
@x=SUBSTRING(@str_id,1,2)
@str_id=max(@x)
return @str_id
end
提示@x附近有语法错误,谢谢!
returns varchar(15)
as
begin
declare @x varchar(15)
@x=SUBSTRING(@str_id,1,2)
@str_id=max(@x)
return @str_id
end
提示@x附近有语法错误,谢谢!
set @str_id=max(@x)
你自己试试
create function Ma_x(@str_id varchar(15))
returns varchar(15)
as
begin
declare @x varchar(15)
select @x=SUBSTRING(@str_id,1,2)
select @str_id=max(@x)
return @str_id
end
--你这用函数不是多此一举么!select substring(col,1,2) from tb where len(col) >= 2