CREATE TABLE [dbo].[TABLE1] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=1) NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , primary key(a,b)
)
CREATE TABLE [dbo].[TABLE2] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=2) NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , primary key(a,b)
)create view vvv
as
select * from table1
union all
select * from table2
go
update vvv set c = '0' where b=1go
drop view vvv
drop table table1,table2
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=1) NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , primary key(a,b)
)
CREATE TABLE [dbo].[TABLE2] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=2) NOT NULL ,
[c] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , primary key(a,b)
)create view vvv
as
select * from table1
union all
select * from table2
go
update vvv set c = '0' where b=1go
drop view vvv
drop table table1,table2
解决方案 »
- 用了数据库复制后,服务器容易死机?
- SQL Server 2005 Express Edtion的JDBC驱动程序
- SQL Server 如何访问DB2数据库
- 含有变量的交叉表,请高手指教.
- 误删C:\Program Files\Microsoft SQL Server\MSSQL\Data下的文件怎么办?
- 快来下吧:Microsoft SQL Server 2005 简体中文企业版(32位)
- insert语句中的into是干什么用的?
- 请教我用python读取NT上的SQL-SERVER中的中文数据出现乱码...
- 如何监控数据库中某个数据表的变化?
- win2k下sqlserver连接问题!各位大虾救命呀!
- 我写了一个ODBC SDK的c程序,已通过编译,可是出现link错误。
- 数据恢复
服务器: 消息 170,级别 15,状态 1,行 4
第 4 行: 'COLLATE' 附近有语法错误。
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=1) NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
CREATE TABLE [dbo].[TABLE2] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=2) NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
go
create view vvv
as
select * from table1
union all
select * from table2
go
update vvv set c = '0' where b=1go
drop view vvv
drop table table1,table2
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=1) NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
CREATE TABLE [dbo].[TABLE2] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=2) NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
go
create view vvv
as
select * from table1
union all
select * from table2
go
update vvv set c = '0' where b=1go
drop view vvv
drop table table1,table2
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=1) NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
CREATE TABLE [dbo].[TABLE2] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] check(b=2) NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
go
create view vvv
as
select * from table1
union all
select * from table2
go
update vvv set c = '0' where b=1go
drop view vvv
drop table table1,table2
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
CREATE TABLE [dbo].[TABLE2] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] NOT NULL ,
[c] [char] (10) NULL , primary key(a,b)
)
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] NOT NULL ,
[c] [char] (10)
) ON [PRIMARY]
GOCREATE TABLE [dbo].[TABLE2] (
[a] [int] IDENTITY (1, 1) NOT NULL ,
[b] [int] NOT NULL ,
[c] [char] (10)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TABLE1] ADD
CONSTRAINT [CK_TABLE1] CHECK ([b] = 1)
GOALTER TABLE [dbo].[TABLE2] ADD
CONSTRAINT [CK_TABLE2] CHECK ([b] = 2)
GOALTER TABLE [dbo].[TABLE1] ADD
CONSTRAINT [PK_TABLE1] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GOALTER TABLE [dbo].[TABLE2] ADD
CONSTRAINT [PK_TABLE2] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GOcreate view vvv
as
(select * from table1)
union all
(select * from table2)
go
update vvv set c = '0'