sample67.sql

来自「T-SQL示例大全」· SQL 代码 · 共 38 行

/* 文件名称: Sample67.sql */

USE 北风贸易

DECLARE @Customer nvarchar(40),
                  @Contact nvarchar(30),
                  @Phone nvarchar(24)

DECLARE Customer_Cursor CURSOR FOR
  SELECT 公司名称, 联系人, 电话 FROM 客户
  ORDER BY 公司名称

OPEN Customer_Cursor

FETCH NEXT FROM Customer_Cursor
  INTO @Customer, @Contact, @Phone 

-- 检查 @@FETCH_STATUS 的值以便决定是否
-- 要继续执行循环以便提取更多的数据记录
WHILE @@FETCH_STATUS = 0

  BEGIN

    PRINT '公司名称: ' + @Customer
    PRINT '联系人: ' + @Contact
    PRINT '电话: ' + @Phone
    PRINT REPLICATE('-',30)

    FETCH NEXT FROM Customer_Cursor
      INTO @Customer, @Contact, @Phone

  END

CLOSE Customer_Cursor

DEALLOCATE Customer_Cursor