34,594
社区成员
发帖
与我相关
我的任务
分享
Create function my_func(@a int,@b int)
returns int
as
begin
declare @c int
set @c=@a+@b
return @c
end
Create proc my_proc
as
select dbo.my_func(1,4)
exec my_proc
create proc temp_proc
as
declare @sql varchar(1000)
select @sql='create proc temp_ccc as select 1'
exec(@sql)
exec temp_proc
exec temp_ccc