CREATE TRIGGER insertnews ON dbo.info
after INSERT
AS
update [dbo].[info] set content=content+b.id
from info a join inserted b on a.id=b.id
after INSERT
AS
update [dbo].[info] set content=content+b.id
from info a join inserted b on a.id=b.id
ID:INT 自加一
content:TEXT
目的:
我想将INSERT后新插入行的ID值读去,然后将这个值当一个上传文件的文件名。
FOR INSERT
AS update [dbo].[info] set content=content+id where id in (select id from inserted)