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 |
|
ayamas
Aged Yak Warrior
552 Posts |
 Posted - 2006-05-27 : 04:09:44
|
| Hi all,How to insert a value from one table to another table ex name from one column of one table to the name column of another table but while inserting it is not necessary that there should be a value in the name column of the first table.If there is null value in first column then NA should be inserted instead of NULL.Can it be done with case statement?Thanks in advance |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-05-27 : 04:13:36
|
| Somthing like this Insert Into Tbl1(Col1)Select IsNull(Col1,'N/A') From Tbl2If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
|
|
|
Inserting from one table to another