MS SQL 2005 – VIII. – novinky v T-SQL podruhé - The Diigo Meta page

• 08 Jul 08
  

  Mr. DiGi

  mssql 2005 database

  • ROW_NUMBER () OVER ( [ <partition_by_clause> ] <order_by_clause> )
  • Ošetrenie chýb pomocou konštrukcie TRY CATCH
  • SET XACT_ABORT OFF BEGIN TRY  BEGIN TRAN  INSERT INTO VynimkaT2 VALUES (4)    INSERT INTO VynimkaT2 VALUES (5)   /* !!! cudzi kluc */    INSERT INTO VynimkaT2 VALUES (6)   COMMIT TRAN  PRINT 'Transakcia potvrdena' END TRY BEGIN CATCH  ROLLBACK  PRINT 'Transakcia odvolana' END CATCH

  1 more annotation...

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.