Hello, I have a bcp script that generates stored procedure code output as shown below.
bcp "select RTRIM(LTRIM(c.text)) FROM sys.objects AS o INNER JOIN sys.syscomments AS c ON o.object_id = c.id WHERE o.type = 'P' AND o.name = 'sp_ic9av0_dx_length'" queryout "\\dbserver1\j$\Backup\NG Sps\sp_ic9av0_dx_length.sql" -t -c -r "\t" -SServer1 -T -dMyDb
There is a formatting issue in the output script that prevents it from compiling without modifying it first. I believe it has something to do with a space after the line terminator. Notice there is a space in the highlighted column name below. If I simply remove the space, the stored procedure will compile. Is there a wat to instruct bcp to handle this scenario correctly?
AND patient_provider_role_.txt_prov ider_role = @provider_role
Thank you,
DaveK
Try to execute this query with BCP instead of querying the sys.syscomments table:
SELECT OBJECT_DEFINITION(object_id) FROM sys.objects WHERE type = 'P' AND name = 'sp_ic9av0_dx_length'
July 21, 2020 at 1:40 pm
Thank you HanShi, that worked perfectly!
DaveK
July 21, 2020 at 1:42 pm
Glad I could help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply