最近在做一个SQL执行工具,发现在选择的的时候,例如选中下面的SQL语句,数据库端是怎么知道把它拆分4条SQL执行。
select * from sys.sysprocesses
select * from test.[dbo].ClusterTest
insert into test.[dbo].ClusterTest
select * from test.[dbo].ClusterTest
select * from test.[dbo].ClusterTest
where Id=1
------解决思路----------------------
语法
[ WITH <common_table_expression>]
SELECT select_list
[ INTO new_table ]
[ FROM table_source ]
[ WHERE search_condition ]
[ GROUP BY group_by_expression]
[ HAVING search_condition]
[ ORDER BY order_expression [ ASC
------解决思路----------------------
DESC ] ]
第一句 from sys.sysprocesses 后面直接跟 SELECT 是不符合语法的,需要分句。