或者这么写: insert into displayfield set id=88 tablename='customer' fieldname='88'
insert into displayfield(id,tablename,fieldname) values --------### (88,'customer','88')
insert into displayfield(id,tablename,fieldname) values(88,'customer','88')
insert into displayfield(id,tablename,fieldname) values(88,'customer','88')
s 是不能少的,value 不能显示关键字
to:fingsoft(志强) insert into displayfield set id=88 tablename='customer' fieldname='88', 能这样用?
你看一下你是不是把id設置成主鍵了 create proc insert_into @id int, @tablename varchar(1000), @fieldname varchar(1000) as if exists(select * from displayfield where Id=@id) update displayfield set id=@id,tablename=@tablename,fieldname=@fieldname else insert into displayfield(id,tablename,fieldname) values(id,tablename,fieldname) go你可以把他寫成存儲過程,把id設置成變量,就可以避免這問題了 調用exec insert_into 88,'customer','88'
呵呵 楼上的多是高手啊!~ 是values
create proc insert_into @id int, @tablename varchar(1000), @fieldname varchar(1000) as if exists(select * from displayfield where Id=@id) update displayfield set id=@id,tablename=@tablename,fieldname=@fieldname else insert into displayfield(id,tablename,fieldname) values(@id,@tablename,@fieldname) go 少寫@了
values --------###
(88,'customer','88')
insert into displayfield set id=88 tablename='customer' fieldname='88',
能这样用?
create proc insert_into
@id int,
@tablename varchar(1000),
@fieldname varchar(1000)
as
if exists(select * from displayfield where Id=@id)
update displayfield set id=@id,tablename=@tablename,fieldname=@fieldname
else
insert into displayfield(id,tablename,fieldname) values(id,tablename,fieldname)
go你可以把他寫成存儲過程,把id設置成變量,就可以避免這問題了
調用exec insert_into 88,'customer','88'
楼上的多是高手啊!~
是values
@id int,
@tablename varchar(1000),
@fieldname varchar(1000)
as
if exists(select * from displayfield where Id=@id)
update displayfield set id=@id,tablename=@tablename,fieldname=@fieldname
else
insert into displayfield(id,tablename,fieldname) values(@id,@tablename,@fieldname)
go
少寫@了
還有可能是你把ID設置主鍵。有可能是插入了一條重復記錄