Home Forums Programming General Copy SP RE: Copy SP
yaip
SSCrazy
Points: 2656
More actions
December 16, 2004 at 7:51 am
#534149
I have
INSERT tbl2
SELECT id,fname,lname from tbl1
WHERE ref# = '123'
This works fine but what if I just wanted to insert fname and leave lname out (which would insert NULLS in that column).