复制CREATE TABLE [dbo].[t1]( [c1] [nchar](10) NOT NULL,视图 [c2] [nchar](20) NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[t2]( [Id] [int] IDENTITY(1,1) NOT NULL, [c1] [nchar](10) NOT NULL, [c2] [nchar](20) NOT NULL, [IsHandled] [bit] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[t2] ADD CONSTRAINT [DF_t2_IsHandled] DEFAULT ((0)) FOR [IsHandled] GO --生成数据 INSERT INTO [test].[dbo].[t1]([c1],[c2]) VALUES (a1,a2) INSERT INTO [test].[dbo].[t1]([c1],[c3]) VALUES (a1,a3) INSERT INTO [test].[dbo].[t1]([c1],[c4]) VALUES (a1,a4) INSERT INTO [test].[dbo].[t1]([c1],[c5]) VALUES (a1,a5) INSERT INTO [test].[dbo].[t1]([c1],[c6]) VALUES (a1,a6) INSERT INTO [test].[dbo].[t1]([c1],[c7]) VALUES (a1,a7) INSERT INTO [test].[dbo].[t1]([c1],[c8]) VALUES (a1,a8) INSERT INTO [test].[dbo].[t1]([c1],[c9]) VALUES (a1,a9) INSERT INTO [test].[dbo].[t1]([c1],[c10]) VALUES (a1,a2) INSERT INTO [test].[dbo].[t1]([c1],[c11]) VALUES (a1,a11) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.
相关文章
精彩导读
热门资讯
关注我们
