Sqlserver 迴圈表

標籤：ons   arch   print   var   int   ast   sts   ide   exists   

CREATE TABLE dbo.[User] (  UID BIGINT IDENTITY ,Name VARCHAR(50) NOT NULL ,Pwd VARCHAR(50) NOT NULL ,CONSTRAINT PK_User PRIMARY KEY CLUSTERED (UID)) ON [PRIMARY]

-- 方法2：使用表變數-- 聲明表變數DECLARE @temp TABLE(    UID BIGINT,    Name VARCHAR(50),    Pwd VARCHAR(50));-- 將源表中的資料插入到表變數中INSERT INTO @temp(UID, Name, Pwd )SELECT UID,Name,Pwd FROM [User]ORDER BY UID;-- 聲明變數DECLARE    @UID AS BIGINT,    @Name AS VARCHAR(50),    @Pwd AS VARCHAR(50);    WHILE EXISTS(SELECT UID FROM @temp)BEGIN    -- 無序堆top1 有索引 top1  SET ROWCOUNT 1 無差別    SELECT top 1 @UID= UID, @Name= Name,@Pwd= Pwd FROM @temp;     -- SELECT @UID,@Name,@Pwd    PRINT ‘主鍵‘+ cast(@UID as varchar(50))+‘使用者名稱‘+@Name+‘密碼‘+@Pwd   -- SET ROWCOUNT 0        DELETE FROM @temp WHERE UID=@UID;END

 

Sqlserver 迴圈表