How to get SQL code using sp_helptext?
Posted on 2002-04-21
Hi, i'm trying to use sp_helptext to get the SQL code using a PreparedStatement and ResultSet, but the only thing i can get out is the number of line's it has.
The current code looks something like this,
currentQueryBuffer.append("exec " + DatabaseName + "..sp_helptext " + StoredProcName);
PS = DBConn.prepareStatement(currentQueryBuffer.toString());
Results = PS.executeQuery();