1008>> SELECT * FROM View_Ship_Gama WHERE 1=1 AND SONUM NOT IN ( SELECT SONum FROM OpenDataSource('SqlOleDb', 'Data source=DBSTTLSZ1; user id=ITUSER;password=ITACCESS').TEST.dbo.ShipSO as SS where 1=1 and View_Ship_Gama.SONUM= SS.SONum and View_Ship_Gama.PRONUM= SS.ProNum and View_Ship_Gama.LOT= SS.Lot ) 1009>> SELECT * FROM View_Ship_Gama WHERE 1=1 AND RTRIM(LTRIM(CUS)) =RTRIM(LTRIM('3MJ ')) AND NOT Exists ( SELECT SONum FROM OpenDataSource('SqlOleDb','Data source=DBSTTLSZ1; user id=ITUSER;password=ITACCESS').TEST.dbo.ShipSO as SS where 1=1 and RTRIM(LTRIM(View_Ship_Gama.SONUM))= RTRIM(LTRIM(SS.SONum)) and RTRIM(LTRIM(View_Ship_Gama.PRONUM))= RTRIM(LTRIM(SS.ProNum)) and RTRIM(LTRIM(View_Ship_Gama.LOT))=RTRIM(LTRIM( SS.Lot)) ) 1010>> select ShipCard.ShipId,isNull(tCount.coun1, 0) As coun1 convert(varchar,isNull(tCount.coun1,0) )+'/'+ convert(varchar,ShipCard.CardBoxQty) as CardBoxQty_Conv, IfCompose=CASE WHEN ShipSO.StandardBoxQty=0 then 0 WHEN (ShipSO.StandardBoxQty<>0) and (ShipCard.CardBoxQty=ShipSO.StandardBoxQty) then 0 else 1 end, from ShipCard left outer join ShipSO on ( ShipCard.ShipId = ShipSO.ShipId and ShipCard.SONum = ShipSO.SONum and ShipCard.ProNum =ShipSO.ProNum and ShipCard.Lot= ShipSO.Lot ) left outer join Ship on ( ShipCard.ShipId= Ship.ShipId ) left outer join ( select CardGuid,count(*) as coun1 from CardBox where 1=1 group by CardGuid) as tCount on (ShipCard.CardGuid =tCount.CardGuid ) left outer join CardBox on ( ShipCard.CardGuid= CardBox.CardGuid ) Where 1 = 12001> <%if (RS.Tables[0].Rows[i][5].ToString() =="UnFinish") {%> <td align=center><%if(RS.Tables[0].Rows[i]["CreatedBy"].ToString()==Session["UserID"].ToString() || "ADMIN"==Session["UserID"].ToString()){%> <img align=absmiddle style="border-style: none;cursor:hand" src="image/delete.gif" onclick = "txtI.value='<%Response.Write(RS.Tables[0].Rows[i][0].ToString());%>'" ;btnDelete.click();"><%}%></td><%}else{%> <td align=center><%if(RS.Tables[0].Rows[i]["CreatedBy"].ToString()==Session["UserID"].ToString() || "ADMIN"==Session["UserID"].ToString()){%> <img align=absmiddle style="border-style: none;cursor:hand" src="image/delete.gif" onclick=click_finish()><%}%></td> <%}%><button class="button" id="btnDelete" type="button" runat="server" onclick="if(!doConfirm()) return false;" style="WIDTH:0px"> </button> Function click_finish() { /* alert(strCode); */ event.cancelBubble=true; alert("Have Scan finish!"); return false; }
111.dmp就是你要导入的文件。
111.dmp就是你要导入的文件。 imp>可以用system用户导入吗?
可以用*.dmp中用户TestOk具有(system,sys)权限,然后在新的同名数据库下建立Testok,
但导入数据时只有TestOk用户的数据,但*.dmp原库中其他用户的环境怎么没有,是什么原因?
请帮忙回答,谢谢!
SELECT * FROM View_Ship_Gama WHERE 1=1 AND SONUM NOT IN (
SELECT SONum FROM OpenDataSource('SqlOleDb',
'Data source=DBSTTLSZ1; user id=ITUSER;password=ITACCESS').TEST.dbo.ShipSO as SS where 1=1
and View_Ship_Gama.SONUM= SS.SONum and View_Ship_Gama.PRONUM= SS.ProNum and View_Ship_Gama.LOT= SS.Lot
)
1009>>
SELECT * FROM View_Ship_Gama WHERE 1=1 AND RTRIM(LTRIM(CUS)) =RTRIM(LTRIM('3MJ '))
AND NOT Exists ( SELECT SONum FROM
OpenDataSource('SqlOleDb','Data source=DBSTTLSZ1; user id=ITUSER;password=ITACCESS').TEST.dbo.ShipSO
as SS where 1=1
and RTRIM(LTRIM(View_Ship_Gama.SONUM))= RTRIM(LTRIM(SS.SONum))
and RTRIM(LTRIM(View_Ship_Gama.PRONUM))= RTRIM(LTRIM(SS.ProNum))
and RTRIM(LTRIM(View_Ship_Gama.LOT))=RTRIM(LTRIM( SS.Lot))
)
1010>>
select ShipCard.ShipId,isNull(tCount.coun1, 0) As coun1
convert(varchar,isNull(tCount.coun1,0) )+'/'+ convert(varchar,ShipCard.CardBoxQty) as CardBoxQty_Conv,
IfCompose=CASE WHEN ShipSO.StandardBoxQty=0 then 0
WHEN (ShipSO.StandardBoxQty<>0) and (ShipCard.CardBoxQty=ShipSO.StandardBoxQty) then 0 else 1
end,
from ShipCard left outer join ShipSO on ( ShipCard.ShipId = ShipSO.ShipId
and ShipCard.SONum = ShipSO.SONum and ShipCard.ProNum =ShipSO.ProNum and ShipCard.Lot= ShipSO.Lot
)
left outer join Ship on ( ShipCard.ShipId= Ship.ShipId )
left outer join ( select CardGuid,count(*) as coun1 from CardBox where 1=1 group by CardGuid) as tCount on (ShipCard.CardGuid =tCount.CardGuid )
left outer join CardBox on ( ShipCard.CardGuid= CardBox.CardGuid )
Where 1 = 12001>
<%if (RS.Tables[0].Rows[i][5].ToString() =="UnFinish") {%>
<td align=center><%if(RS.Tables[0].Rows[i]["CreatedBy"].ToString()==Session["UserID"].ToString() || "ADMIN"==Session["UserID"].ToString()){%>
<img align=absmiddle style="border-style: none;cursor:hand" src="image/delete.gif"
onclick = "txtI.value='<%Response.Write(RS.Tables[0].Rows[i][0].ToString());%>'"
;btnDelete.click();"><%}%></td><%}else{%>
<td align=center><%if(RS.Tables[0].Rows[i]["CreatedBy"].ToString()==Session["UserID"].ToString() || "ADMIN"==Session["UserID"].ToString()){%>
<img align=absmiddle style="border-style: none;cursor:hand" src="image/delete.gif"
onclick=click_finish()><%}%></td>
<%}%><button class="button" id="btnDelete" type="button" runat="server" onclick="if(!doConfirm()) return false;" style="WIDTH:0px">
</button>
Function click_finish()
{
/*
alert(strCode);
*/
event.cancelBubble=true; alert("Have Scan finish!");
return false;
}