PS. Chestia cu "CREATE TABLE tabela AS SELECT ... FROM ..." nu există în SQL Server (ci doar în Oracle şi MySQL, cred). În SQL Server există doar "INSERT INTO tabela SELECT ... FROM ..." sau "SELECT ... INTO tabela FROM ...".


 da, greselea mea. Scuze.


asa cum zice msdn

The amount of logging for SELECT...INTO depends on the recovery model in effect for the database. Under the simple recovery model or bulk-logged recovery model, bulk operations are minimally logged. With minimal logging, using the SELECT… INTO statement can be more efficient than creating a table and then populating the table with an INSERT statement. For more information, see Operations That Can Be Minimally Logged.


Multumesc,