- A table is created by sa/dbo.
- A user is granted update permission on the table.
- Executing the following queries give different results:
Query 1: update test set col1=t.col1 from test t where t.col2='row10'
Query 2: update pubs2.dbo.test set col1=t.col1 from pubs2.dbo.test t where t.col2='row10'
Query 3: update test set col1=t.col1 from pubs2.dbo.test t where t.col2='row10'
SAP Adaptive Server Enterprise (ASE) all versions
database, owner, select, update, insert, delete, statement , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.