22,209
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE [dbo].[tuc_insertVehile]
AS
BEGIN
delete from VehileTable
if not exists(select 1 from master.dbo.sysservers where srvname = 'srv_lnk')
begin
exec master.dbo.sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.0.218'
exec master.dbo.sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','sa'
end
exec('insert into VehileTable select VehileMark, SIMID from srv_lnk.GPSManager.dbo.VehileTable')
exec master.dbo.sp_dropserver 'srv_lnk','droplogins'
select '' as haha
END
CallableStatement cstmt = null;
cstmt = db.getConnection().prepareCall("{call dbo.tuc_insertVehile()}");
cstmt.executeQuery();