如何將語句:
declare client_mrp Cursor
for Select tabtemp.CardNo
from Openrowset('SQLOLEDB','WNX06';'sa'; ,
'select CardNo from QDMIS.dbo.Client') as tabtemp替換成如下使用變量參數語句格式:declare client_mrp Cursor
for Select tabtemp.CardNo
from Openrowset
('SQLOLEDB',@User_Server;@User_Name;@User_Password,
'select CardNo from QDMIS.dbo.Client') as tabtemp
declare client_mrp Cursor
for Select tabtemp.CardNo
from Openrowset('SQLOLEDB','WNX06';'sa'; ,
'select CardNo from QDMIS.dbo.Client') as tabtemp替換成如下使用變量參數語句格式:declare client_mrp Cursor
for Select tabtemp.CardNo
from Openrowset
('SQLOLEDB',@User_Server;@User_Name;@User_Password,
'select CardNo from QDMIS.dbo.Client') as tabtemp
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货