Stored procedures which has dynamic string queries inside

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Stored procedures which contain dynamic query such as concatenating a
sql string, are not generated as they should.

What is the expected output? What do you see instead?
A stored procedure that contains;
 DECLARE @SQL nvarchar(500)
 SET @SQL='SELECT * from MY_TABLE'
 EXEC(@SQL)

generated as it returns an 'int', however it should return the DataTable.

Original issue reported on code.google.com by sacos...@gmail.com on 19 Oct 2008 at 3:17

[GoogleCodeExporter]

arda bu sorunu cozmek icin aklıma gelen tek sey. Bu sp'lerin icine bir comment 
yazmak.
-- RETURNS DataTable
-- RETURN int

gibi. dinamik sorgunun ne yapacağını bilmek imkansız.

Original comment by ati.ozgur on 4 Dec 2008 at 12:42