vw_GC_Department.sql 396 B

12345678910111213141516171819202122232425
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE VIEW dbo.vw_GC_Department AS
  6. SELECT
  7. [Hauptbetrieb],
  8. [Standort],
  9. [Hauptbetrieb_ID],
  10. [Hauptbetrieb_Name],
  11. [Standort_ID],
  12. [Standort_Name],
  13. [Marke_ID],
  14. [Marke_Name],
  15. [Gruppe_ID],
  16. [Gruppe_Name],
  17. [Site]
  18. FROM [GC].[data].[GC_Department];
  19. GO
  20. SET QUOTED_IDENTIFIER OFF
  21. GO
  22. SET ANSI_NULLS OFF
  23. GO
  24. GO