SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Hi i have a weird problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ornit cohen
Starting Member

3 Posts

Posted - 05/26/2013 :  09:07:17  Show Profile  Reply with Quote
Hi everyone
i'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 help
Ornit

TG
Flowing Fount of Yak Knowledge

USA
5914 Posts

Posted - 05/26/2013 :  09:19:42  Show Profile  Reply with Quote
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 Optimizer
TG
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 05/27/2013 :  01:08:07  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ornit cohen
Starting Member

3 Posts

Posted - 05/27/2013 :  09:38:18  Show Profile  Reply with Quote
Hi thanks for your answers
i'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.
Go to Top of Page

MIK_2008
Flowing Fount of Yak Knowledge

Pakistan
1050 Posts

Posted - 05/27/2013 :  12:21:16  Show Profile  Reply with Quote
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)?

Cheers
MIK

Edited by - MIK_2008 on 05/27/2013 12:21:38
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 05/27/2013 :  13:45:40  Show Profile  Reply with Quote
quote:
Originally posted by ornit cohen

Hi thanks for your answers
i'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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000