各位大侠帮帮忙，怎样把这段存储过程转换为SQL语句，在线等，先谢谢了！

整个过程相当于执行如下语句： select * from Product 如果过程没写错，应是如下意思吧： select * from Product where (@ProdID = '' or ProdID like '%'+@ProdID+'%') and (@ProdName = '' or ProdName like '%'+@ProdName+'%')