SQL Server OPENQUERY

Discussion of programming on Linux, including shell scripting, perl, python, c/c++, mono, java. Whatever tickles your fancy.

SQL Server OPENQUERY

Postby cwackked » Tue Mar 22, 2005 11:01 pm

Anyone know anything about the OPENQUERY in SQL SERVER? This might be off topic..but I need a response quick.

Im running a simple SELECT using OPENQUERY..from a SQL SERVER to a linked DB2 server..and the results do not contain all the rows..only 100 or 200 of the 300,000. Any idea why this is?
cwackked
Lance Naik
 
Posts: 33
Joined: Sat Aug 30, 2003 7:23 am
Website: http://desimart.net
WLM: cwackked@hotmail.com

Re:

Postby LinuxFreaK » Tue Mar 22, 2005 11:49 pm

Dear cwackked,
Salam,

FYI, http://msdn.microsoft.com/library/en-us ... z_5xix.asp

Best Regards.
Farrukh Ahmed
LinuxFreaK
Site Admin
 
Posts: 5132
Joined: Fri May 02, 2003 10:24 am
ICQ: 82075802
Website: http://www.linuxpakistan.net/wiki/index.php?pagename=LinuxFreak
WLM: f4fahmed@hotmail.com
Yahoo Messenger: f4fahmed@yahoo.com
AOL: linuxpakistan@aol.com
Location: Karachi


Return to “%s” Programming

Who is online

Users browsing this forum: No registered users and 2 guests

cron