DECLARE @sql nvarchar(4000)DECLARE @cou intSET @sql='INSERT INTO people values('''+'xiaohong'+''');select @temp=@@IDENTITY' EXEC sp_executesql @sql, N'@temp int out', @cou OUTINSERT INTO child VALUES(@cou, '小兰')

CREATE PROC chjj @name nvarchar(1000)ASBEGIN　　DECLARE @sql nvarchar(4000)　　DECLARE @cou int　　SET @sql='INSERT INTO people values('''+@name+''');select @temp=@@IDENTITY' 　　EXEC sp_executesql @sql, N'@temp int out', @cou OUT　　IF @cou > 85     BEGIN      INSERT INTO child VALUES(@cou, '小兰')    END END调用存储过程：EXEC dbo.chjj '李厚鑫s' sql存储过程怎么接收datatable作为入参