例如:
( ( a = '' and b = '') or (c like '' and d= '') ) or ( e = '' and c ='')
SQL条件是不确定比较复杂的字符串, 但是中间有些text的字段用like查询非常慢,
如C是大字段like查询, 怎么用程序进行优化, 语句效果不变
...全文
12115打赏收藏
求一段SQL规律, 或者代码. 求各位老大们帮帮忙...
例如: ( ( a = '' and b = '') or (c like '' and d= '') ) or ( e = '' and c ='') SQL条件是不确定比较复杂的字符串, 但是中间有些text的字段用like查询非常慢, 如C是大字段like查询, 怎么用程序进行优化, 语句效果不变
Important
ntext , text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.