比如:
create Trigger TriggerTest On ColumnDefine
after insert
as
begin
create view test
as
select * from FilterColumn
end在创建这个Trigger的时候出现错误:
Msg 156, Level 15, State 1, Procedure TriggerTest, Line 5
Incorrect syntax near the keyword 'view'.请问应该怎么解决, 非常感谢!
create Trigger TriggerTest On ColumnDefine
after insert
as
begin
create view test
as
select * from FilterColumn
end在创建这个Trigger的时候出现错误:
Msg 156, Level 15, State 1, Procedure TriggerTest, Line 5
Incorrect syntax near the keyword 'view'.请问应该怎么解决, 非常感谢!
BEGIN
IF EXISTS (SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = N'<view_name, sysname, view_test>')
DROP VIEW <view_name, sysname, view_test>
GOCREATE VIEW <view_name, sysname, view_test>
AS
<select_statement, , SELECT * FROM authors>