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 |
|
ornit cohen
Starting Member
3 Posts |
 Posted - 2013-05-26 : 09:07:17
|
| Hi everyonei'm new to sql programming and now i'm working on a database that a friend of mine programmed and managing it pretty well. but now i encountered a weird problem where there is data that is clearly showing on the access interface, but when i ask for this data on the sql server manager, it shows NULL . how come???thank you for any helpOrnit |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-05-26 : 09:19:42
|
| could be several possibilities. The interface could be replacing NULLs with an expression or constant value, or the code that retrieves the data from the database (like a stored procedure) could be replacing the NULL values, or it could be that when you select the data manually via Management Studio you are not selecting the same row(s) that you observe from the interface.Be One with the OptimizerTG |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-27 : 01:08:07
|
| How are you accessing the data in SQL? are you using linked server or any distributed methods? or are you bringing data to sql server table and then trying to query?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
ornit cohen
Starting Member
3 Posts |
Posted - 2013-05-27 : 09:38:18
|
| Hi thanks for your answersi'm accessing the data in sql by a "select" query.the data im searching for is old, and i can see it through a query that is being run by Access, but if i do the "select" it shows NULL for part of the rows. |
|
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-05-27 : 12:21:16
|
| Post both queries; the one that is sent by the application to pull data and the one you've written (which is not pulling the data)?CheersMIK |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-27 : 13:45:40
|
quote:
Originally posted by ornit cohen
Hi thanks for your answersi'm accessing the data in sql by a "select" query.the data im searching for is old, and i can see it through a query that is being run by Access, but if i do the "select" it shows NULL for part of the rows.
So can i assume you use a distrbuted query method?If you can post statement used it would definitely help!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Hi i have a weird problem