34,576
社区成员
发帖
与我相关
我的任务
分享
IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'tba')
BEGIN
DROP TABLE tba
END
GO
CREATE TABLE tba
(
col1 VARCHAR(100),
col2 INT,
col3 VARCHAR(100)
)
GO
DECLARE @Sql VARCHAR(1000)
SET @Sql = 'SELECT * FROM tba WHERE ' + stuff((select ' AND ' + name + ' LIKE ''关键字%'''
from syscolumns AS A
where A.id = OBJECT_ID('tba') for xml path('')),1,5,'')
EXEC( @Sql)
SELECT * FROM TAB WHERE CHARINDEX('关键字',col1,0)
UNION
SELECT * FROM TAB WHERE CHARINDEX('关键字',col2,0)
where col1 like '%xx%' or col2 like '%xx%'.....................
where col1 like '%xx%' or col2 like '%xx%'.....................