谁能帮我做这一道SQL Server 题目

2025-04-13 19:10:55
推荐回答(1个)
回答1:

DECLARE @search_sno varchar(30)
go
create proc search_name1 (@search_sno varchar(30))
as
select stu_name,stu_dept from student
where stu_sno=@search_sno
go
EXEC search_name1 @search_sno = '2'
go
执行通过!