12612.htm

来自「一本很基础的SQL讲解」· HTM 代码 · 共 21 行

<link href="./dzs_cs.css" rel="stylesheet" type="text/css" />
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="24" align="center" valign="bottom" class="d_font3">SQL SERVER中直接循环写入数据</td>
      </tr>
      <tr>
        <td height="3" bgcolor="#E3E3E3"></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td class="d_font4"><P>declare @i int<BR>set @i=1<BR>while @i&lt;30<BR>begin<BR>&nbsp;&nbsp; insert into test (userid) values(@i)<BR>&nbsp;&nbsp; set @i=@i+1<BR>end</P></td>
      </tr>
      <tr>
        <td class="d_font4">&nbsp;</td>
      </tr>
    </table>