发信人: foxzz()
整理人: hunter__fox(2002-03-16 23:35:39), 站内信件
|
请参考:
1、在mssql中建立存储过程
CREATE PROCEDURE finddoub AS
select emp_id from employee
group by emp_id
having count(*) > 1
2、
open data mytest
nhand=sqlconnect('pub')
m_issucc=sqlexec(nhand,"{call finddoub}","temp1")
sele temp1
brow
---- 天行健,君子以自强不息
|
|