--try create proc test ( @sql varchar(8000) ) as exec (@sql) go
不行哦 create procedure p1(@sql varchar(300)) as exec(@sql) GO; 语法对么,他报语法错误 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@sql varchar(300)) as exec(@sql) go' at line 1
create proc test
(
@sql varchar(8000)
)
as
exec (@sql)
go
create procedure p1(@sql varchar(300))
as
exec(@sql)
GO;
语法对么,他报语法错误
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@sql varchar(300)) as exec(@sql) go' at line 1