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 |
|
DP978
Constraint Violating Yak Guru
269 Posts |
 Posted - 2009-12-17 : 08:56:04
|
| This has little application, but could be time saving in something I'm doing at the moment so I figured Id ask. If there a way to apply something like the ISNULL() function to an entire table?Ive got some 20 columns and multiple joins so there are nulls popping up all over the place, didn't know if I could get ISNULL([Column Name], 0) to be applied to everything.Doubt it, but figured I'd ask :) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-12-17 : 09:02:00
|
| You can't apply it for a tableor do it in the application when getting dataMadhivananFailing to plan is Planning to fail |
 |
|
|
DP978
Constraint Violating Yak Guru
269 Posts |
Posted - 2009-12-17 : 09:05:19
|
| Thanks, figured there was little chance, didn't hurt to ask :) |
|
|
|
|
|
|
Quick ISNULL() Question