Test Loop

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

DECLARE @nodeName varchar(255)

set @nodeName = 'uenms-qvappa001,uenms-qvappa002'

while len(@nodeName) > 0
begin
  -- print left(@nodeName, charindex(',', @nodeName+',')-1)
  print 'Remove data for Node: ' + @nodename
  set @nodeName = stuff(@nodeName, 1, charindex(',', @nodeName+','), '')
end

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results