declare @i int exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out
declare @i int exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
declare @i int exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out 引号没对整齐
declare @i int exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
declare @i int exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
declare @i int exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
楼主是想知道一个查询语句各个部分的执行顺序吧?参考一下这个: 8) SELECT (9) DISTINCT (11) <TOP_specification> <select_list> (1) FROM <left_table> (3) <join_type> JOIN <right_table> (2) ON <join_condition> (4) WHERE <where_condition> (5) GROUP BY <group_by_list> (6) WITH {CUBE | ROLLUP} (7) HAVING <having_condition> (10) ORDER BY <order_by_list>
declare @i int exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out两个表一个,动态SQL中常用到
declare @i int exec getPage 'cedian_sale','id','TypeID','Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out
declare @i int exec getPage 'cedian_sale','id','TypeID','Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out 'id,TypeID,Sale_Name'缺少引号,'Sale_Name like '%中国%'多了一个引号 每个常量单独在一起
declare @i int exec getPage 'cedian_sale', 'id, TypeID,Sale_Name', 'id', 100,3,0, 'Sale_Name like ''%中国%''', @i out
declare @i int
exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out
declare @i int
exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out
引号没对整齐
exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
declare @i int
exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out
8) SELECT (9) DISTINCT (11) <TOP_specification> <select_list>
(1) FROM <left_table>
(3) <join_type> JOIN <right_table>
(2) ON <join_condition>
(4) WHERE <where_condition>
(5) GROUP BY <group_by_list>
(6) WITH {CUBE | ROLLUP}
(7) HAVING <having_condition>
(10) ORDER BY <order_by_list>
exec getPage 'cedian_sale','id,TypeID,Sale_Name','id',100,3,0,'Sale_Name like ''%中国%''',@i out两个表一个,动态SQL中常用到
exec getPage 'cedian_sale','id','TypeID','Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out
exec getPage 'cedian_sale','id','TypeID','Sale_Name','id',100,3,0,'Sale_Name like %中国%',@i out
'id,TypeID,Sale_Name'缺少引号,'Sale_Name like '%中国%'多了一个引号
每个常量单独在一起
exec
getPage
'cedian_sale',
'id,
TypeID,Sale_Name',
'id',
100,3,0,
'Sale_Name like ''%中国%''',
@i out