向空表批量添加数据
我在SQL中创建了张表week(week_ID,week_basetime)
现在欲在其中自动加入week_ID写入如下代码：
DECLARE @INT AS INT
SET @INT = 0
WHILE @INT < 500000 --这里设置需要插入多少行
BEGIN
SET @INT = @INT + 1
INSERT INTO week(week_ID,week_basetime) SELECT @INT,''
END
结果提示 week表不存在 怎么回事？
[解决办法]
use databasename
DECLARE @INT AS INT
SET @INT = 0
WHILE @INT < 500000 --这里设置需要插入多少行
BEGIN
SET @INT = @INT + 1
INSERT INTO week(week_ID,week_basetime) SELECT @INT,''
END
[解决办法]
什么数据库？
检查WEEK表是否存在
