如何同时向多个表插入记录
CREATE TABLE [dbo].[Table1] (
[tab1] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[id1] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Table2] (
[tab2] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[id2] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Table3] (
[tab3] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[id3] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
三个表table1,2,3
插入以下记录:
id1=id2=id3=1
id1=id2=id3=2
id1=id2=id3=3
...