create proc test1(
@id varchar(50)
)
as
declare @name varchar(50)
set @name = (select name from table1 where id = @id)
select @name问下 想得到这个name怎么实现?
@id varchar(50)
)
as
declare @name varchar(50)
set @name = (select name from table1 where id = @id)
select @name问下 想得到这个name怎么实现?
@id varchar(50)
)
as
declare @name varchar(50)
select @name=name from table1 where id =@id)
select @name
create proc test1(
@id varchar(50),
@name varchar(50) output
)
as
select @name=name from table1 where id = @id
--调用:
declare @n varchar(50)
exec test1 1,@n output
select @n
create proc test1(
@id varchar(50)
)
as
declare @name varchar(50)
select @name=name from table1 where id =@id
select @name
--....为变量@id的值
create proc test1(
@id varchar(50)
,@name varchar(50) output
)
as begin
set @name = (select name from table1 where id = @id)
end
godeclare @name varchar(50)
declare @id varchar(50) set @id='100052'
exec test1 @id, @name output
print @name