当没有查询到任何数据的时候,就会出错,这个问题怎么解决?CREATE PROCEDURE [dbo].[confirm]
(@code char(6),
@psw char(10),
@name char(8) output)
AS
select @name=name
from temployee
where ( employeeno=@code) and (psw=@psw)GO
(@code char(6),
@psw char(10),
@name char(8) output)
AS
select @name=name
from temployee
where ( employeeno=@code) and (psw=@psw)GO
create PROCEDURE [dbo].[confirm]
(@code char(6),
@psw char(10),
@name char(8) output)
ASselect @name=name
from temployee
where ( employeeno=@code) and (psw=@psw)
if @name is null
set @name=''GO