create procedure A
as
declare @xml nvarchar(50), @id int,@name nvarchar(50)
select @xml='asdfasfdasdf',@id=1,@name='sdfasdfsafd'
go
create procedure B
as
declare @xml nvarchar(50), @id int,@name nvarchar(50)
set @xml='asdfasfdasdf'
set @id=1
set @name='sdfasdfsafd'
go
set statistics time on
exec A
set statistics time off
go
set statistics time on
exec B
set statistics time off
as
declare @xml nvarchar(50), @id int,@name nvarchar(50)
select @xml='asdfasfdasdf',@id=1,@name='sdfasdfsafd'
go
create procedure B
as
declare @xml nvarchar(50), @id int,@name nvarchar(50)
set @xml='asdfasfdasdf'
set @id=1
set @name='sdfasdfsafd'
go
set statistics time on
exec A
set statistics time off
go
set statistics time on
exec B
set statistics time off