create function getUserName (@Name varchar(120)) returns varchar
as
begin
declare @UserName varchar(24)
if len(@Name)>12
Set @UserName=substring(@Name,1,12)
return @UserName
end
go
create function getUserName (@Name varchar(120)) returns varchar
as
begin
declare @UserName varchar(24)
if len(@Name)>12
Set @UserName=substring(@Name,1,12)
return @UserName
end
go
转载于:https://www.cnblogs.com/wangdetian168/archive/2008/08/12/1266011.html