access_time 7 years ago languageEnglish
more_vert

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

visibility 4,648 comment 2
For Teradata developers, if you have no SQL Server installed, please go to the following link to download the SQL Server 2014 Expression Edition. http://www.microsoft.com/en-us/server-cloud/Products/sql-server-editions/sql-server-express.aspx It is easy to get started and free to use.
info Last modified by Administrator 9 months ago
thumb_up 1

comment Comments

5 years ago link more_vert
account_circle Raymond
@Tiru INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE is a standard ANSI SQL. For lock statement, it is the syntax for Teradata. ACCESS lock is similar to set transaction isolation level as READ UNCOMMITTED in other database, i.e. SQL Server.
format_quote

person Tiru access_time 5 years ago
Re:Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

what is the exact query in ANSI sql for below mentioned query ? LOCKING SOURCE_TABLE FOR ACCESS INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE;
5 years ago link more_vert
account_circle Tiru
what is the exact query in ANSI sql for below mentioned query ? LOCKING SOURCE_TABLE FOR ACCESS INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE;

Forum discussions for column Teradata.

Follow Kontext

Get our latest updates on LinkedIn or Twitter.

Want to contribute on Kontext to help others?

Learn more