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 |
|
satheesh
Posting Yak Master
152 Posts |
 Posted - 2012-09-17 : 05:47:08
|
| Dear All,I have a SP in that i am retrieving and inserting data in to a #temp table.I am using this sp for long time.But today i stuck with this error 'Attempting to set a non-NULL-able column's value to NULL'I have used ISNULL() before now i removed this uswell but still i am getting the same error.How to fix this issue?Any help will be highly appreciated!ThanksRegards,SG |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-17 : 06:26:41
|
| Usually people use the ISNULL function when they want to provide a value where something would otherwise have been null. So removing the ISNULL functions may be what is causing the problem. Can you post the query you are using along with some sample data? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-17 : 10:58:36
|
| if you're getting error even when using ISNULL then the column you're trying to use as substitute for NULL values may also contain NULLspost your used query so as to help us understand what's happening------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
non-NULL-able column value