The stored procedure is a good way to solve a lot of problems, with a time for nearly a week, is on the problem of the stored procedure, the stored procedure is everything in the background, the function is to pass two view names and views The field name, create a table during the stored procedure to form a cross-reported type. It is normal when executed in the background, but when calling the stored procedure at the front desk, it is always created normally. Use an event tracker to track, determine or have an empty data of a temporary table, or not to connect the field. But it has not been able to have a solution. Today, under the guidance of the teacher, finally there is a result. It turns out that the parameter used in the PB front desk or during the stored procedure, the parameters used must not be a view, the PB performs the stored procedure, the view is in the stored procedure It is interpreted as a SELECT statement, resulting in the above problem, after the parameters and operation objects are changed to the table, the problem is solved!
