运行存储过程,查询结果两张表,填充 da.Fill(ds); 时ds报错:
”SELECT 失败,因为下列 SET 选项的设置不正确: 'ARITHABORT'。……“
解决办法:存储过程里面加 Set ARITHABORT ON 就ok 了。
即:BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
Set ARITHABORT ON