当用 SqlParameter 传值时,譬如:
private const string SQL= "select * from 表 where 字段 like @TypeId +'%' and ((字段1like '%'+ convert(varchar(200),@InfoName) +'%') or (字段like '%' + convert(varchar(200),@Info) + '%'))";
传到sql server中执行的是
exec sp_executesql N'select * from 表 where 字段 like @TypeId+''%'' and ((字段1 like ''%'' + convert(varchar(200),@InfoName)+ ''%'') or (字段2like ''%'' + convert(varchar(200),@Info) +''%''))',
N'@TypeId int,@InfoName ntext,@Info ntext',
@TypeId = 11, @InfoName = N'h', @Info = N''