上海大學(xué)數(shù)據(jù)庫上機(jī)作業(yè)上機(jī)練習(xí)-資料下載頁
2025-07-24 14:41本頁面
【正文】 INTO @no,@name 打印表標(biāo)題PRINT 39。職工號 姓名39。WHILE @@FETCH_STATUS =0BEGIN 打印一行數(shù)據(jù)PRINT CAST(@no AS char(8))+@name 提取下一行數(shù)據(jù)FETCH NEXT FROM w_cursor INTO @no,@nameEND 關(guān)閉游標(biāo)CLOSE w_cursor 釋放游標(biāo)DEALLOCATE w_cursorGO factoryGO DECLARE @num intSELECT @num=COUNT(*)FROM workerPRINT 39。原職工人數(shù)：39。+CAST(@num AS CHAR(3))GO DECLARE @num intBEGIN TRANSACTION 啟動(dòng)事務(wù)插入一個(gè)職工記錄INSERT INTO worker VALUES(20,39。陳立39。,39。女39。,39。55/03/0839。,1,39。75/10/1039。,4)PRINT 39。插入一個(gè)職工記錄39。SELECT @num=COUNT(*)FROM workerPRINT 39。職工人數(shù)：39。+CAST(@num AS CHAR(3))ROLLBACK TRANSACTION 回滾事務(wù)GO PRINT 39?；貪L事務(wù)39。DECLARE @num int SELECT @num=COUNT(*)FROM workerPRINT 39。職工人數(shù)：39。+CAST(@num AS CHAR(3))GO4
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號-1