1.delete from tb where tb.id in (select * from (select id1 from tb1) as table3)
运行后结果:select * 不可少(不提示错误,delete语句不运行),as table3不可少。
2.存储过程中delete语句不执行,语句在外部已经验证过了
3.函数function中返回值(returns)不能是表,sql server中可以
1.delete from tb where tb.id in (select * from (select id1 from tb1) as table3)
运行后结果:select * 不可少(不提示错误,delete语句不运行),as table3不可少。
2.存储过程中delete语句不执行,语句在外部已经验证过了
3.函数function中返回值(returns)不能是表,sql server中可以