Advertisement
Ortund

Untitled

Nov 8th, 2011
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. while @i < 23
  2. BEGIN
  3.     IF @i = 23
  4.         break
  5.     ELSE
  6.         UPDATE Modules
  7.         SET Presentation = 'Modules/Module' + @i + 'Module ' + @i + '-' + (SELECT ModuleName FROM Modules WHERE ModuleID = @i) + '.ppt'
  8.         WHERE ModuleID = @i
  9.         SET @i = @i + 1
  10.     END
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement