Home Forums SQL Server 2012 SQL Server 2012 - T-SQL USE statement inside create view statement possible? RE: USE statement inside create view statement possible?

  • February 17, 2018 at 1:35 pm

    #1980179

    pietlinden - Saturday, February 17, 2018 1:31 PM

    Why not just use a the 3-part naming convention when creating your view?

    USE Tempdb;
    GO
    CREATE VIEW MyView
    AS
    SELECT CustomerID
    FROM Galactic.dbo.Customer;

    You're right.  USE is not allowed in views or stored procedures apparently.  Thanks.