好像一个字段多个条件查询, 类似google查询,前几天看到哟类似的帖子split() like 等 你查一下看看
最后用动态语句 DELCARE @sql nvarchar(4000) Set @sql = 'SELECT * FROM table WHERE 1=1' IF @t IS NOT NULL SET @sql = @sql + ' AND 字段1 like ..' IF @t1 IS NOT NULL SET @sql = @sql + ' AND 字段2 like ..' IF @t2 IS NOT NULL SET @sql = @sql + ' AND 字段3 like ..exec @sql
BEGIN...END
IF...ELSE
GOTO
CONTINUE
WHILE...BREAK
WAITFOR但是能实现几乎所有的逻辑控制,建议多看看相关关键字的帮助
DELCARE @sql nvarchar(4000)
Set @sql = 'SELECT * FROM table WHERE 1=1'
IF @t IS NOT NULL
SET @sql = @sql + ' AND 字段1 like ..'
IF @t1 IS NOT NULL
SET @sql = @sql + ' AND 字段2 like ..'
IF @t2 IS NOT NULL
SET @sql = @sql + ' AND 字段3 like ..exec @sql