create PROCEDURE GetSql
@ParentID int,
@SqlStr varchar (1000) output
AS
BEGIN
END
DECLARE @a int
DECLARE @b varchar(1000)
set @a = 1
exec getsql @a,@b out
print @b
create PROCEDURE GetSql
@ParentID int,
@SqlStr varchar (1000) output
AS
BEGIN
END
DECLARE @a int
DECLARE @b varchar(1000)
set @a = 1
exec getsql @a,@b out
print @b