•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 427,195 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,161 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 512 | Replies: 2
 |
•
•
Join Date: Feb 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Problem with NULL in SQL 2000 I have below query inside sp.
select groupno,a from table1
where groupno <> 'Test'
It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help
thank you
select groupno,a from table1
where groupno <> 'Test'
It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help
thank you
•
•
Join Date: Aug 2006
Location: Egypt
Posts: 762
Reputation:
Rep Power: 4
Solved Threads: 59
Master Poster
select groupno,a from table1
where groupno <> 'Test' OR groupno is null
where groupno <> 'Test' OR groupno is null
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ajax asp database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development firefox background-position problem solved hacker management studio 2005 microsoft msdn news office security software sql sql cache dependency with polling-based invalidation survey update panel scroll problem vista you tried to assign the null value to a variable that is not a variant data type
- SQL Query Analyzer Problem (Database Design)
- Getting "DB_E_ERRORSINCOMMAND" even when execute is successful (C)
- HELP - Invalid object error related to sqlole null bug in MSSQL 2000 (MS SQL)
- somthing wrong about using JDBC-ODBC (JSP)
Other Threads in the MS SQL Forum
- Previous Thread: Column data to column heading
- Next Thread: Remove a row in excel
