SQLServer存储过程

概述create proc [dbo].[PhoneRec] (@haoma varchar(32),@ser varchar(16) output) as if @haoma='' and @ser='' begin select a.serverid,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.release

create proc [dbo].[PhoneRec] (@haoma varchar(32),@ser varchar(16) output)
as
if @haoma='' and @ser=''
begin
select a.serverID,c.serverip,a.filename,b.callernumber,b.callednumber,b.createtime,b.releasetime
from dbo.AGENTRECfile as a
inner join dbo.ColOG as b
on a.coID=b.coID
inner join dbo.DEVICECFG as c
on a.serverID=c.serverID
order by b.createtime asc
end
else if @haoma=''
on c.serverID=@ser and a.serverID=c.serverID
else if @ser=''
where b.callernumber=@haoma or b.callednumber=@haoma
end
else

drop proc PhoneRec
exec PhoneRec 'xxx','yyy'

总结

以上是内存溢出为你收集整理的SQLServer存储过程全部内容，希望文章能够帮你解决SQLServer存储过程所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。