ALTER PROCEDURE dbo.getMan
@name nvarchar(50)=null,@return nvarchar(5)
AS
/* SET NOCOUNT ON */
if @name is not null
begin
SELECT top 1 @return=dbo.notices.employeeid
FROM dbo.employees INNER JOIN
dbo.notices ON dbo.employees.id = dbo.notices.employeeid
WHERE employees.name = @name
return @return
end
else
SELECT dbo.notices.employeeid
FROM dbo.employees INNER JOIN
dbo.notices ON dbo.employees.id = dbo.notices.employeeid
@name nvarchar(50)=null,@return nvarchar(5)
AS
/* SET NOCOUNT ON */
if @name is not null
begin
SELECT top 1 @return=dbo.notices.employeeid
FROM dbo.employees INNER JOIN
dbo.notices ON dbo.employees.id = dbo.notices.employeeid
WHERE employees.name = @name
return @return
end
else
SELECT dbo.notices.employeeid
FROM dbo.employees INNER JOIN
dbo.notices ON dbo.employees.id = dbo.notices.employeeid
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货