data.GC_Department.sql 410 B

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