① CREATE PROCEDURE Orders(@Condition varchar(255)) AS SELECT * FROM Orders Where ID = @Condition GO② CREATE PROCEDURE Orders(@Condition varchar(255)) AS Declare @SQLStr varchar(255) Set @SQLStr = 'SELECT * FROM Orders Where ID = ' + @Condition Exec(@SQLStr) GO是不是这样就叫动态SQL吗?(对不起,小弟很菜!!!)
CREATE PROCEDURE Orders(@Condition varchar(255))
AS
SELECT * FROM Orders Where ID = @Condition
GO②
CREATE PROCEDURE Orders(@Condition varchar(255))
AS
Declare @SQLStr varchar(255)
Set @SQLStr = 'SELECT * FROM Orders Where ID = ' + @Condition
Exec(@SQLStr)
GO是不是这样就叫动态SQL吗?(对不起,小弟很菜!!!)