-
Equivalent Oracle Code
Hi,
Could anyone provide me an Oracle equivalent code/Logic in SQL Server, for this below mentioned code in SQL Server.
Regards,
K.Diwakar
UPDATE ISQM.texaminations
SET DateApproved = CURRENT_TIMESTAMP,
UserApproved = @UserID
FROM ISQM.tbatches B
INNER JOIN ISQM.teventsbatches EB
ON B.SystemID = EB.SystemID
AND B.BatchID = EB.BatchID
INNER JOIN ISQM.tevents V
ON EB.SystemID = V.SystemID
AND EB.EventID = V.EventID
INNER JOIN ISQM.texaminations X
ON V.SystemID = X.SystemID
AND V.EventID = X.EventID
WHERE B.BatchID = @BatchID
AND B.SystemID = @SystemID
Last edited by diwakar; 09-21-2004 at 05:58 AM.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|