Hvad gør jeg forkert her? (Create View)
IF not EXISTS (SELECT name FROM dbo.sysobjects WHERE name = N'SMSILOG@All' )BEGIN
CREATE VIEW dbo.SMSILOG@All
AS
SELECT [TimeStamp], [User], Severity, Description, Form, CodeBlock
FROM dbo.tblPMSystemLog
WHERE (Application = 'Safety Monitoring')
END
--- Giver ---
Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'VIEW'.
