https://www.sqlines.com/ 2026-04-14T05:22:04+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2011-07-01T13:18:46+00:00 https://www.sqlines.com/articles/sql-server/local_and_global_temporary_tables?rev=1309526326&do=diff * Local Temporary Tables * Global Temporary Tables * Temporary Table Limitations * Emulating Oracle Package Variables using Temporary Tables In SQL Server, you can use local and global temporary tables. Local temporary tables are visible only in the current session, while global temporary tables are visible to all sessions. text/html 2012-06-02T16:38:37+00:00 https://www.sqlines.com/articles/sql-server/oracle-sequences?rev=1338655117&do=diff In Oracle, a sequence object (CREATE SEQUENCE) is used to generate a sequence of unique integer values. The main purpose of sequences: * Generate primary keys for tables (ID values) * Specific use of sequences not related to table IDs, or sharing a single sequence among multiple tables text/html 2011-10-09T11:22:48+00:00 https://www.sqlines.com/articles/sql-server/select_into_when_multiple_rows?rev=1318159368&do=diff When you need to retrieve a single row from a table or query, you can use the following syntax in SQL Server: DECLARE @name VARCHAR(30); SELECT @name = city FROM cities; But what happens if SELECT returns multiple rows? Assume we have the following table definition and data: text/html 2011-08-03T20:55:23+00:00 https://www.sqlines.com/articles/sql-server/transact-sql-errors-runtime?rev=1312404923&do=diff During conversion to SQL Server, you can figure out all syntax issues and successfully create objects such as stored procedures, functions, triggers in the SQL Server database without any errors. Unfortunately, some issue still can appear when you try to execute the converted code.