本人菜鸟。。请教个问题！

[tcwxx]

我先建立个模型
Create mining model membercard
(
account_id text key,
district_id text discrete,
type1 text discrete predict
)
using Microsoft_Decision_Trees
然后训练
insert into membercard
(account_id,district_id,type1
Openquery(bishe,'select account.account_id,district_id,type from account,disp where account.account_id=disp.account_id)

为什么会提示：“Openquery”的语法不正确。刚开始学这个，望解答.

[风影极光]

insert语句搭配select语句，可以从一个表中取出现成的记录，来输入到另一个表中，而且一次可以新增多笔记录。
语法格式如下：
INTERET [INTO] table name[(column list)]
SELECT_statemnet
详细可参考：http://www.cnblogs.com/mingle/archive/2010/03/19/mssql-insert.html

[百年树人]

建议楼主去网上找些例子看看，这个语法错得很显然。

[dawugui]

什么语言?看不懂,帮顶.

[SQL77]

EXEC sp_addlinkedserver 'OracleSvr', 
   'Oracle 7.3', 
   'MSDAORA', 
   'ORCLDB'
GO
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles') 
GO




insert into membercard
(account_id,district_id,type1)

SELECT * FROM Openquery(bishe,'select account.account_id,district_id,type from account,disp where account.account_id=disp.account_id')

[-狙击手-]

77强大

[SQL77]

[Quote=引用 4 楼 happyflystone 的回复:]
77强大
[/Quote]
石头大哥好

[feixianxxx]

[Quote=引用 4 楼 happyflystone 的回复:]
77强大
[/Quote]
昨天没回我？

[--小F--]

insert into a select * from b

[tcwxx]

[Quote=引用 3 楼 sql77 的回复:]

SQL code
EXEC sp_addlinkedserver 'OracleSvr',
'Oracle 7.3',
'MSDAORA',
'ORCLDB'
GO
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO




insert into membercard
(a……
[/Quote]还是不行啊。。。我看书上这么写的。。
insert into membercard
(account_id,district_id,type1)
Openquery([bishe],'select account.account_id,district_id,type from account,disp where account.account_id=disp.account_id)
可还是运行不了。。。