C# SqlParameter中使用Like

sql = "SELECT....FROM... where ID=@ID AND name LIKE @name + '%' "

或

sql = "SELECT....FROM... where ID=@ID AND name LIKE '%' + @name + '%' "