Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newuser123
Starting Member
7 Posts |
 Posted - 2010-01-07 : 05:02:29
|
| I have one table tb1 as followcol1 col2 1 a 1 b 1 c1 null1 null2 d2 w2 o3 q3 nulli want to insert above rows into tb2 with skipping null valuesso output should becol1 co121 a 1 b 1 c2 d2 w2 o3 q |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-07 : 05:09:16
|
insert tb2 (col1, col2)select col1,col2from tb1where col2 is not null
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
skip null value while inserting the rows