sqlserver 批量更新

select  * from [LPicture]
UPDATE [dbo].[LPicture] SET [picGroup] = '3213'
 WHERE  LPictureid in(1,2);
1
2
3
select * from LPicture where LPictureid not in ('')
select * from LPicture where LPictureid not in (null) --什么也查不出来
select * from LPicture where LPictureid not in (select contentlist from DPSeting where DPSetingid=2)

  

posted @   dreamw  阅读(2483)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示