When execute it gives error:
Conversion failed when converting the varchar value 'select Max(Angle_price) from Manufact_angle' to data type int and when i change entire data type from int to varchar it gives unexpected results
stored procedure is
CREATE PROCEDURE Compare
@angleMax int Output ,
@angleMin int Output
AS
BEGIN
declare @angleMaxsql int
declare @angleMinsql int
set @angleMaxsql='select Max(Angle_price) from Manufact_angle ';
set @angleMinsql='select Min(Angle_price) from Manufact_angle ';
set @angleMax=@angleMaxsql
set @angleMin=@angleMinsql
END