SQL Looping temp table and reading data
I have following script to create temp data
DECLARE @Name NVARCHAR(100), @Marks INT
DECLARE @MYTABLE TABLE
(
[Name][nvarchar](100) NULL,
[Marks][INT] NULL
)
INSERT INTO @MYTABLE ([Name],[Marks]) VALUES ('Mark',50);
INSERT INTO @MYTABLE ([Name],[Marks]) VALUES ('Steve',50);
INSERT INTO @MYTABLE ([Name],[Marks]) VALUES ('Don',50);
Now I want loop it, as shown in below script
SELECT @MaxPK = MAX(PK) from @MYTABLE
WHILE @PK <= @MaxPK
BEGIN
SET @Name = SELECT Name from @MYTABLE
SET @Marks = SELECT Marks from @MYTABLE
print @Name
print @Marks
SET @PK = @PK + 1
END
But I get error near SELECT statement.
"Incorrect syntax near the keyword SELECT"!
No comments:
Post a Comment