上海大學數(shù)據(jù)庫上機作業(yè)上機練習-資料下載頁
2025-07-24 14:41本頁面
【正文】 INTO @no,@name 打印表標題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 關閉游標CLOSE w_cursor 釋放游標DEALLOCATE w_cursorGO factoryGO DECLARE @num intSELECT @num=COUNT(*)FROM workerPRINT 39。原職工人數(shù)：39。+CAST(@num AS CHAR(3))GO DECLARE @num intBEGIN TRANSACTION 啟動事務插入一個職工記錄INSERT INTO worker VALUES(20,39。陳立39。,39。女39。,39。55/03/0839。,1,39。75/10/1039。,4)PRINT 39。插入一個職工記錄39。SELECT @num=COUNT(*)FROM workerPRINT 39。職工人數(shù)：39。+CAST(@num AS CHAR(3))ROLLBACK TRANSACTION 回滾事務GO PRINT 39?；貪L事務39。DECLARE @num int SELECT @num=COUNT(*)FROM workerPRINT 39。職工人數(shù)：39。+CAST(@num AS CHAR(3))GO4
研究報告相關推薦
鄂ICP備17016276號-1