sql 函数的使用

create function aa(@int int,@one int) returns int
as
begin

return @int+@one
end
go
drop function aa

select dbo.aa(1,2)

select * from area
update area set id=300 where id=3

select dbo.aa(a.id,b.id),a.id,b.id from area a,city b where a.father=b.cityid

create function F_Split
(
@SourceSql varchar(8000),--字符串
@StrSeprate varchar(10)--分隔符
)
returns varchar(1000)
as
begin
declare @i int
set @SourceSql=rtrim(ltrim(@SourceSql)) --格式化字符串
set @i=charindex(@StrSeprate,@SourceSql) --获取分隔符位置
if @i>=1 --如果大于1
begin
set @SourceSql=substring(@SourceSql,1,@i-1) --取字符的上半截
--set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i) --取字符的下半截
end
return @SourceSql
end
go
declare @str varchar(200)
set @str='ascd|dsadsa'
select dbo.f_split(@str,'|')