SELECT @temp = ISNULL(point, 0) FROM dbo.User where Nid=6
如果User表中的point字段为null的话,则对@temp赋值0
转载于:https://www.cnblogs.com/wupeiqi/p/3357550.html