我在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表是否存在