select ID,MainFunctionID,MainFunction,MainID,MainIDDescription,ModeID,ActionPageName,ActionBtnName,Description,IsActive,ModifyID,ModifyDate
FROM T_LogWriteSet where MainID = ''' AND Description Like '%'%' 请问 AND Description Like '%'%' 最后面一个%为什么没用呢?
FROM T_LogWriteSet where MainID = ''' AND Description Like '%'%' 请问 AND Description Like '%'%' 最后面一个%为什么没用呢?
FROM T_LogWriteSet where MainID = ''' AND Description Like 'g'g' Incorrect syntax near 'g'.
if object_id('tb') is not null drop table tb
gocreate table tb(id int identity(1,1),name varchar(10))
insert tb select
'' union all select
'1' union all select
'1''2' union all select
'9'''
/*
select * from tb
id name
----------- ----------
1
2 1
3 1'2
4 9'(4 行受影响)
*/
select * from tb where name like '%''%'id name
----------- ----------
3 1'2
4 9'(2 行受影响)???
FROM T_LogWriteSet where MainID = '''' AND Description Like '%''%'
select '''luoyou' t union all
select '2luoyoumou' union all
select '3luo''youmou' ) t
where t.t like '%''%';
ID,
MainFunctionID,MainFunction,MainID,
MainIDDescription,ModeID,ActionPageName,ActionBtnName,
[Description],IsActive,ModifyID,ModifyDate
FROM T_LogWriteSet
where MainID = '''' AND [Description] Like '''%''%'
select '''luoyou' t union all
select '2luoyoumou' union all
select '3luo''youmou' ) t
where t.t like '%''%';