DECLARE @id INT,@sql VARCHAR(3333);--声明两个变量;
SELECT @id=3; --给变量@id赋值;
SELECT @sql='SELECT f_id,f_name FROM fruits WHERE f_id= '
EXEC(@sql + @id);---等同于“SELECT f_id,f_name FROM fruits WHERE f_id=3 ”
SQL SERVER 动态查询
最新推荐文章于 2023-07-08 02:12:16 发布