SQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或访问被拒绝 SQLState = 01000, NativeError = 53 Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). NULL
各位大虾,我试了半天才觉得导出语句是错的,约束条件好象没有用,我用下面的语句:select distinct n.e,n.f,n.g from sd..xishud xi,sd..mb n,sd..zt z where (select m.h from (select a.* from mb a,zt b where a.e=b.e and a.f=b.f and a.g=b.g) m) in (select m.h from xishud xi,sd..mb n,(select a.* from mb a,zt b where a.e=b.e and a.f=b.f and a.g=b.g) m where m.a*xd_a+m.b*xd_b+m.c*xd_c+m.d*xd_d=n.a*xd_a+n.b*xd_b+n.c*xd_c+n.d*xd_d group by m.h having count(*)>=100)无论我改成大于等于几,都会把mb表中的所有记录显示出来,这到底是怎么回事呀,错在哪呀,我晕。
EXEC master..xp_cmdshell 'bcp "Select * from pubs..authors" queryout c:\DT.txt -c -Smyserver\sqlserver2000 -Usa -P'
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server 不存在或访问被拒绝
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
NULL
sd..xishud xi,sd..mb n,sd..zt z where
(select m.h from (select a.* from mb a,zt b where a.e=b.e and a.f=b.f and a.g=b.g) m) in
(select m.h from
xishud xi,sd..mb n,(select a.* from mb a,zt b where a.e=b.e and a.f=b.f and a.g=b.g) m
where
m.a*xd_a+m.b*xd_b+m.c*xd_c+m.d*xd_d=n.a*xd_a+n.b*xd_b+n.c*xd_c+n.d*xd_d group by m.h having count(*)>=100)无论我改成大于等于几,都会把mb表中的所有记录显示出来,这到底是怎么回事呀,错在哪呀,我晕。