CREATE PROCEDURE Test
AS
begin
set nocount on
declare @post varchar(20)
select @post=post from member where username='abby'
if @@rowcount<>0
print @post
select post from member where username='abby'
end
go
AS
begin
set nocount on
declare @post varchar(20)
select @post=post from member where username='abby'
if @@rowcount<>0
print @post
select post from member where username='abby'
end
go
呢?
直接不就输出POST值了吗?
CREATE PROCEDURE Test
AS
begin
set nocount on
select post from member where username='abby'
end