问大家个问题,大家在开发大项目,写存储过程的时候,是把增删查改写到同一条存储过程呢,还是分开四条存储过程?例如:
1.四个存储过程:student_select,student_add,student_update,student_delete
2.合并在同一条存储过程:student
create proc student
@id,@name,...,@type
AS
switch (@type)
begin
case 1:
begin
select * from tb_student
end
case 2:
...
case 3:
...
case 4:
...
end
1.四个存储过程:student_select,student_add,student_update,student_delete
2.合并在同一条存储过程:student
create proc student
@id,@name,...,@type
AS
switch (@type)
begin
case 1:
begin
select * from tb_student
end
case 2:
...
case 3:
...
case 4:
...
end
写一起以后修改或有些啥判断的话,密密麻麻的只要2个就够了sp_insert 和sp_updateselect 和 delete 一般不需要写成存储过程