alter proc stu
@where varchar(100)
as
declare @sql nvarchar(200)
set @sql='select sname,birth,CAST(score AS DECIMAL(18,2)) AS score from student'
set @sql=@sql+' '+@where
exec(@sql)
go
exec stu 'where 1=1'
CAST(score AS DECIMAL(18,2)) AS score