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 |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2002-04-12 : 13:19:23
|
| How is the optionSET CONCAT_NULL_YIELDS_NULL OFF Is it OK to set this option in the begining of stored procedure or i would be better of using isnull function for all the fields?I have 35 stored procedures(quite long)where i am using this statement.Any input would be appreciated.Thanks. |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2002-04-12 : 13:31:24
|
| I think the CONCANT_NULL etc. is better that a lot of function calls inside the proc. |
 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-04-12 : 13:31:24
|
| I use it in a number of stored procedures without problems.I always turn it back on at the end of the procedure though. |
|
|
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
Posted - 2002-04-12 : 13:36:21
|
| I read it somwhere that the stored procedure has to recompile if we put this option.rita |
|
|
|
|
|
|
SET CONCAT_NULL_YIELDS_NULL OFF