Showing posts with label solve. Show all posts
Showing posts with label solve. Show all posts

Wednesday, March 28, 2012

Query

Hi Friends,
I have the following query how can solve this any help........
i want to do my rowcount round and not the flot and i can only change in query and not in program

set ROWCOUNT 5.1
select * from Test1

AshutoshI am really not sure what you are asking here. Could you please explain further?

Terri|||ROWCOUNT must be an integer. You cannot return 5.1 rows from your query...|||... how are you going to return .1 of a query?

Friday, March 9, 2012

QA goes, EM doesn't (previously posted on microsoft.public.sqlserver.server)

sory for repost but nobody on sqlserver.server helped me to solve this
:-(((((((((
---
AFAIK QA uses ODBC and EM uses OLE DB right?
anyway, I can connect using QA but not using EM.
tried with IP addredd too with no avail
what's wrong?
tia
Zarko
server: active-pasive cluster win2000as sp3, sql2000sp3a
client: win xp pro, sql2000sp3aWhat is the exact error that is generated?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.