Stored procedure having aggreagte function in select statement
Brought to you by:
ickzon
If an aggregate function e.g count(*) is used in procedure, the column name gets blank value.
DB:MSSQL 2012
Procedure used:
CREATE procedure [dbo].[testprocedure6]
As
select COUNT(*) from table
GO
code snippet:
rs = databaseMetaData.getProcedureColumns(...
while (rs.next())
{rs.getString(COLUMN_NAME)}
Please ignore the above code snippet. This error I am getting after execution of procedure.
ResultSetMetaData rsMetadata = rs.getMetaData();
String columnName = rsMetadata.getColumnName(column_index);