常用SQL语句积累

--批量设置表中某字段为固定值

update dbo.LampList set LampGroupAddress=ISNULL(LampGroupAddress,'')+1 

--批量设置表中某字段为Null

UPDATE dbo.LampList SET LampAddress=NULL
--批量删除ID大于1024
DELETE FROM dbo.LampList WHERE Id>1024