sqlserver 存储 过程 create procedure proc_menu ?@menuid varchar(50), ?@menutotal int output as begin set nocount on; select @menutotal=count(*) from dbo.lov_menu t where t.menu_id=@menuid; end sqlserver 自 定义 函数 create function s
sqlserver 存储过程
create procedure proc_menu
?@menuid varchar(50),
?@menutotal int output
as
begin
set nocount on;
select @menutotal=count(*) from dbo.lov_menu t where t.menu_id=@menuid;
end
sqlserver 自定义函数
create function sector_name(@sctid varchar(10))
returns varchar(50)
as
begin
declare @ccode varchar(50)
declare @name? varchar(50)
declare @pid varchar(10)
declare @sctpid varchar(10)
declare @spid varchar(10)
select @pid=sct_pid? from sector where sct_id=@sctid
if(@pid=1)
set @ccode=(select sct_nam from sector where sct_id=@sctid)
else if(@pid=0)
set @ccode=(select sct_nam from sector where sct_id=@sctid)
else
begin
select @name? =sct_nam? from sector where sct_id=@sctid
select @sctpid=sct_pid? from sector where sct_id=@pid
if (@sctpid=1)
? set @ccode =(select sct_nam? from sector where sct_id = @pid )+'-'+@name
else
? begin
? while @sctpid 1
begin
? select @spid=sct_pid? from sector where sct_id = @sctpid
? set @ccode =(select sct_nam? from sector where sct_id = @sctpid )+'-'+@name
? set @sctpid=@spid
? if @sctpid=1
break
end?
?end
end
return @ccode
end