插入数据:
declare @i int
set @i=0
while (@i<10)
begin
insert into T_Cashiers (StatID,CashID,Name,CardNo,Pwd,status,Zone,Is_Sub)
values(1,@i,cast(@i AS varchar)+cast(@i AS varchar)+cast(@i AS varchar)+cast(@i AS varchar),@i,8888,1,0,0)
set @i=@i+1
end
对应表结构:
略。