Insert into table(ID,Name) values ('1','2');
Insert into table(ID,Name) values ('2','2');
Insert into table(ID,Name) values ('3','2');
Insert into table(ID,Name) values ('4','2');能不能改为类似Mysql
Insert into table(ID,Name) values ('1','2'),('2','2'),('3','2'),('4','2');谢谢
Insert into table(ID,Name) values ('2','2');
Insert into table(ID,Name) values ('3','2');
Insert into table(ID,Name) values ('4','2');能不能改为类似Mysql
Insert into table(ID,Name) values ('1','2'),('2','2'),('3','2'),('4','2');谢谢
方法二:建议MS想MySQL学习,修改T-SQL语法
SELECT '1','2'
UNION SELECT '2','2'
UNION SELECT '3','2'
UNION SELECT '4','2'
select '1','2'
union
select '2','2'
union
select '3','2'