天使半只翼

摘要： CREATE table #T (s varchar(128)) DECLARE @T table (s varchar(128)) INSERT into #T select 'old value #' INSERT into @T select 'old value @' BEGIN transaction UPDATE #T set s='new value #' UPDATE @T set s='new value @' ROLLBACK transaction SELECT * from #T SELECT * from 阅读全文

摘要： DECLARE @Hid varchar(50), @Hname varchar(50)declare contact_cursor cursor for --声明游标select hotel_id,h_name from hotel where hotel_id<25open contact_cursor --打开游标fetch next from contact_cursor into @Hid,@Hname --游标指针下移一行while @@fetch_status=0 --FETCH语句执行成功begin print @Hid + @Hname fetch next fr... 阅读全文