Good afternnon, thanks for your idea, but its a little bit confusing for me this expression:
i know the characret + is used to concatenate but the expression 'exec sp_spaceused '''
itself what does mean?, when should i use simple quotes or doble quotes, and the construction of this instruction gets me a syntax error,
when using double quotes:
"select 'exec sp_spaceused ''' + name + '' from sysobjects where type = 'U' and name like 'paso_hechos%'"
error: Could not find stored procedure 'select 'exec sp_spaceused ''' + name + '' from sysobjects where type = 'U' and name like 'paso_hechos%''.
without double quotes:
select 'exec sp_spaceused ''' + name + '' from sysobjects where type = 'U' and name like 'paso_hechos%'
output:
exec sp_spaceused 'PASO_HECHOS_TRAFICO_ABONADO
exec sp_spaceused 'PASO_HECHOS_TRAFICO_LLAMADAS
exec sp_spaceused 'PASO_HECHOS_TRAFICO_LLAMADAS_CDRS_TARJETA
exec sp_spaceused 'PASO_HECHOS_TRAFICO_LLAMADAS_ENTRANTE_ELITE
what is wrong with the above sentences?
id appreciate again your help