CREATE PROCEDURE QueryAccout
@kindIndex varchar(2)
AS
declare @TmpStr varchar(30)
set @TmpStr=@kindIndex
begin
if (@kindIndex )= '0' -- 你写成@kingIndex了
begin
select * from Account
end
else
begin
select * from Account where kind = @kindIndex
end
end
@kindIndex varchar(2)
AS
declare @TmpStr varchar(30)
set @TmpStr=@kindIndex
begin
if (@kindIndex )= '0' -- 你写成@kingIndex了
begin
select * from Account
end
else
begin
select * from Account where kind = @kindIndex
end
end
@kindIndex
你写错了,,
@kindIndex varchar(2) --修改 KingIndex varchar(2)
AS
declare @TmpStr varchar(30)
set @TmpStr=@kindIndex
begin
if (@kingIndex )= '0'
begin
select * from Account
end
else
begin
select * from Account where kind = @kindIndex
end
end