分两条语句
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
VALUES ('Projet',112,94 ,100)INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
VALUES ('Projet',112,94 ,10)或者
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
select * from (Select 'Projet' as a,112 as b,94 as c ,100 as d Union all
select 'Projet',112,94 ,100 ) temp
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
VALUES ('Projet',112,94 ,100)INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
VALUES ('Projet',112,94 ,10)或者
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
select * from (Select 'Projet' as a,112 as b,94 as c ,100 as d Union all
select 'Projet',112,94 ,100 ) temp
VALUES ('Projet',112,94 ,100),('Projet',112,94 ,10)写法错了.应该这样写
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
select 'Projet',112,94 ,100
union all select 'Projet',112,94 ,10
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
VALUES ('Projet',112,94 ,100)INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
VALUES ('Projet',112,94 ,10)或者
INSERT INTO DegreeRoleScopeTable(AppID,DegreeID,RoleID,NodeID)
Select 'Projet' ,112 ,94 ,100
Union all
select 'Projet',112,94 ,10
好像确实没有这样的语句。
我在MySQL 上面可以用的,但sql server2000不行了。
不过,我看了一本书上有这样的写法,书上用的就是sql server2000奇怪了。
谢谢大家!接分