SQL Server 定义游标、使用游标及触发器 trigger讲解

    declare Mycursor cursor for
        select UserName,Age,Email from tbUsers

    open Mycursor
        declare @uName varchar(50)
        declare @uAge int
        declare @uEmail varchar(50)
        fetch next from Mycursor into @uName,@uAge,@uEmail
        if (@@fetch_status=0)
        begin
            print @uName
            print @uAge
            print @uEmail
        end
    close Mycursor

    create trigger trg_In ON tbUsers
    after delete
    as
        begin
            insert into tbUsers_backup(Name,Age,Email) select Name,Age,Email from deleted
        end