Friday 12 April 2013

what is difference between Anonymous blocks and Named blocks in sqlserver

Anonymous Blocks :

  • Anonymous blocks are saved in files.
  • don't provide the security.
  • Anonymous blocks are not reusable.
  • Can't be called from front-end application.
  • Every time compile and executed.
Named Blocks :
  • Named blocks are saved in Database.
  • provide the security.
  • Named blocks are reusable.
  • Named blocks can be called from front-end application.
  • One time compile and every time execution.

No comments:

Post a Comment