向空表批量添加数据
我在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表是否存在