如何插入一个字段到SQLSERVER表中，如何写SQL语句
展开全部
更改长度
if Exists(select A.* from syscolumns A inner join sysobjects B on A.id=B.id where B.type = 'U' and
B.name=upper('youtable') and A.name=lower('youfield '))
alter table youtable
alter column youfield char(60) NULL
go
添加
if not exists(select A.* from syscolumns A inner join sysobjects B on A.id=B.id where B.type='U' and B.name=upper('youtable')and A.name=lower('youfield'))
begin
alter table youtable add youfield datetime null
end
go
if Exists(select A.* from syscolumns A inner join sysobjects B on A.id=B.id where B.type = 'U' and
B.name=upper('youtable') and A.name=lower('youfield '))
alter table youtable
alter column youfield char(60) NULL
go
添加
if not exists(select A.* from syscolumns A inner join sysobjects B on A.id=B.id where B.type='U' and B.name=upper('youtable')and A.name=lower('youfield'))
begin
alter table youtable add youfield datetime null
end
go
本回答被提问者和网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
