大家帮我看看这条存储过程为什么不能执行谢谢了
执行时提示"异类查询要求为连接设置 ANSI_NULLS 和 ANSI_WARNINGS 选项。这将确保一致的查询语义。请启用这些选项,然后重新发出查询" 问题出在什么地方呢?谢谢大哥们!
ALTER PROCEDURE dbo.ExportDaybillToUserFee @calmonth datetime AS
exec sp_addlinkedserver @server='UserDB',
@srvproduct=N'',
@provider=N'sqloledb',
@datasrc=N'192.168.72.111'
exec sp_addlinkedsrvlogin 'UserDB','false',null,'sa','sa'
exec(' INSERT INTO UserDB.UserFee.dbo.DayBill
(CallID, UserTelNo, BusinessCallinNo, BusinessName, BeginTime, EndTime,BusinessFeeType, TotalTime, FeeTime, InfoFee, CalDay )
SELECT dbo.DayBill.CallID,dbo.DayBill.UserTelNo, dbo.DayBill.BusinessCallinNo, dbo.DayBill.BusinessName, dbo.DayBill.BeginTime, dbo.DayBill.EndTime,
(CASE Business.BusinessFeeType WHEN 0 THEN (
CASE dbo.Business.CallinFeeType
WHEN 0 THEN (''按时'')
WHEN 1 THEN (''按次'') END)
WHEN 1 THEN (''包月'')
WHEN 2 THEN (''封顶'')
END) ,
dbo.DayBill.TotalTime, dbo.DayBill.FeeTime, dbo.DayBill.InfoFee, dbo.DayBill.CalDay FROM FeeCheckout.dbo.DayBill INNER JOIN FeeCheckout.dbo.Business ON FeeCheckout.dbo.DayBill.BusinessCallinNo = FeeCheckout.dbo.Business.BusinessCallinNo
WHERE (dbo.DayBill.CalDay) = dbo.GetSimpMonth('''+ @calmonth +''')
')
exec sp_dropserver 'UserDB ','droplogins'
GO