34,576
社区成员
发帖
与我相关
我的任务
分享
create procedure selectteacher
@tno
as
select @tno=tno from deleted
select * from teacher
go
create procedure selectteacher
@tno NVARCHAR(100) --变量
as
SET @tno= (select TOP 1 tno from deleted) --读取一个deleted表中的tno值
select * from teacher WHERE tno = @tno --按照读取的tno值去teacher表中查询用户信息
go