刚才试用TOAD,建了个函数,建完了看源代码,发现WITH EXEC AS CALLER这句,请问这句的作用是什么,我baidu和google都找不到答案。ALTER FUNCTION [dbo].[get_new]
(@type nvarchar(10))
RETURNS int
WITH EXEC AS CALLER
AS
BEGIN
return upper(@type)+'-'+convert(varchar(6),getdate(),112)+'-'+cast(1 as varchar(2))
END
(@type nvarchar(10))
RETURNS int
WITH EXEC AS CALLER
AS
BEGIN
return upper(@type)+'-'+convert(varchar(6),getdate(),112)+'-'+cast(1 as varchar(2))
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货