存储过程的传值

来源：百度知道 编辑：UC知道 时间：2024/06/05 03:56:50
CREATE PROCEDURE [insert_class_1]
//参数
(@Class_id [varchar](50),
@Class_department [varchar](50),
@Class_college [varchar](50),
@Class_teacherid [varchar](50),
@Class_name [varchar](50))
//插入语句
AS INSERT INTO [ST_StuManager].[dbo].[ST_class]
( [ST_Class_id],
[ST_Class_department],
[ST_Class_college],
[ST_Class_teacherid],
[ST_Class_name])
VALUES
( @Class_id,
@Class_department,
@Class_college,
@Class_teacherid,
@Class_name)
“[ST_StuManager].[dbo].[ST_class]
这个存储过程 的INSERT INTO语句里将( @Class_id,
@Class_department,
@Class_college,
@Class_teacherid,
@Class_name)
块赋值给( [ST_Class_id],
[ST_Class_department],
[ST_Class_college],
[ST_Class_teacherid],
[ST_Class_name])
块，怎样赋值啊， @Class_id,
@Class_department,
@Class_college,
@Class_teacherid块不是刚定义的么

如：
execute insert_class_1('aaa','bbb','ccc','ddd','eeee');
和C语言中调用函数是一样的
execute 是执行的意思
insert_class_1是你的存储过程名
()里面是参数

---
以上，希望对你有所帮助。