SQL中调用ORACLE存储过程(2)

2019-02-14 23:05

declare @num int

declare @sqls nvarchar(1000) declare @strTableName nvarchar(55) set @strTableName='MCITY'

set @sqls='select @a=count(*) from '+@strTableName exec sp_executesql @sqls,N'@a int output',@num output select @num

（注：以上SQL在sv-02,Qservice下测试通过。）

删除重复数据：

delete top(1) from table where name in( select name from table group by name having count(name)>1 )

SELECT *FROM table WHERE (id IN(SELECT MAX(id) FROM table GROUP BY name))

SQL中调用ORACLE存储过程(2).doc 将本文的Word文档下载到电脑下载失败或者文档不完整，请联系客服人员解决！