存储过程
CREATE PROCEDURE showHy AS
beginupdate hy set xfhj=xfje+xflb*10
end
GO
execute showHy
触发器
CREATE TRIGGER caculateHj
on hy
FOR INSERT, UPDATE, DELETE
AS
BEGIN TRANSACTION
--调用存储过程
EXEC showHy
COMMIT TRANSACTION
带参数存储过程
CREATE PROCEDURE showHyById
@id integer
AS
select * from hy where id=@id
GO
execute showHyById '3'
使用游标
CREATE PROCEDURE testCursor
AS
declare @id int, @name varchar(20);
declare dep_cursor cursor for
select id, hyxm from hy;
open dep_cursor;
fetch next from dep_cursor into @id, @name;
while(@@fetch_status = 0)
begin
--fetch next返回紧跟当前行之后的结果行,并且当前行递增为结果行。如果 FETCH NEXT 为对游标的第一次提取操作,
--则返回结果集中的第一行。NEXT 为默认的游标提取选项。
fetch next from dep_cursor into @id, @name;
print @id;
print @name;
end;
--这是关闭游标
close dep_cursor;
--这是删除游标
deallocate dep_cursor;
GO