Your Ad Here

advanced code snippet search

Posted By

qrist0ph on 06/11/10


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


TSQL Insert in Table

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. USE TestCA
  2. declare @foo int
  3. SET @foo=0
  4. while @foo < 5
  5. begin
  6. INSERT INTO Table_1 VALUES(CAST(@foo AS char) + 'text',CAST(@foo AS char) + 'text','nix','nix')
  7. print 'foo'
  8. SET @foo = @foo +1
  9. end

Report this snippet  

You need to login to post a comment.