declare @i int
set @i=1001
while @i<2000
begin
INSERT INTO [Hotel_Room]([Room_NO] ,[STB_MAC],[Status],[Meno]) VALUES (@i,'00:17:C4:48:'+convert(varchar,@i) ,'false' ,@i)
set @i=@i+1
end
SQL 循环及 字符串转换
最新推荐文章于 2023-04-03 14:33:51 发布
declare @i int
set @i=1001
while @i<2000
begin
INSERT INTO [Hotel_Room]([Room_NO] ,[STB_MAC],[Status],[Meno]) VALUES (@i,'00:17:C4:48:'+convert(varchar,@i) ,'false' ,@i)
set @i=@i+1
end