SQLserver

增

INSERT INTO [dbo].[user](x,y) VALUES(x,y)

删除

delete from [dbo].[all_ele] where fid=x

修改

UPDATE all_ele SET name=s,price=s,quantity=s WHERE fid=s

查

select * from [dbo].[user] where uname=s 

触发器

BEGIN
DECLARE @Lineid int,@fid int,@price varchar(5),@name nvarchar(11)

SELECT @Lineid =qid,@fid=fid,@price=price,@name=name FROM inserted


INSERT INTO sold_goods(gid,sid,price,gname) VALUES(@Lineid,@fid,@price,@name);

END

传送门