sqlserver 存储过程跟自定义函数

sqlserver 存储过程

create procedure proc_menu
[email protected] varchar(50),
[email protected] int output
as
begin
?? set nocount on;
?? select @menuTotal=count(*) from dbo.Lov_menu t where [email protected];
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 [email protected]
if(@pid=1)
?? set @ccode=(select SCT_NAM from SECTOR where [email protected])
else if(@pid=0)
?? set @ccode=(select SCT_NAM from SECTOR where [email protected])
else
begin
?? select @name? =SCT_NAM? from SECTOR where [email protected]
?? select @sctpid=SCT_PID? from SECTOR where [email protected]
?? if (@sctpid=1)
? set @ccode =(select SCT_NAM? from SECTOR where SCT_ID = @pid )[email protected]
?? 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 )[email protected]
??? set @[email protected]
??? if @sctpid=1
????break
?? end?
?end
end
return @ccode
end