andreita_273 Posted January 13, 2017 Share Posted January 13, 2017 Tengo una consulta y esta función es perfecta en sql Select Table_Name, STUFF((SELECT CAST(',' AS varchar(MAX)) + C.COLUMN_NAMEFROM INFORMATION_SCHEMA.COLUMNS Cwhere C.TABLE_NAME = T.TABLE_NAMEORDER BY ORDINAL_POSITIONFOR XML PATH('')), 1, 1, '') as CadenaCamposfrom INFORMATION_SCHEMA.TABLES T pero al implementar el reporte en el jasperserver ya no funciona... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now