create proc se1
@id int,
@age int
as
begin
declare @sql int
set @sql=' select top 1 id from teacher'
print @sql
end
我想取到select top 1 id from teacher'返回值的id 但是总说varchar转化int失败
!
create proc se1@id int output,--输出参数要加关键字output@age intasbegin set @id=(select top 1 id from teacher)end取值,要声明个变量:declare @Myidexec se1 @Myid output,30 --查询下变量的值:select @Myid 如果你想加上age变量的比较代码如下:create proc se1@id int output,--输出参数要加关键字output@age intasbegindelare @sql varChar(1000)set @sql=