|
摘要：
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... 阅读全文
|
