Large queries - sql prompt 'gives up'?

jreynolds

I've noticed after building a few hundred lines of sql that sql prompt basically starts to 'give up' on prompting for previously defined temporary tables.

I would define a temp table in the beginning, and later (no alter table statements anywhere) after a couple of hundred lines of code, it just stops prompting. No errors, but just no prompts.

Anyone else have this issue?

MikeyC

If you search you will find a number of people have complained about this. SQL Prompt only searches x characters before the cursor and y characters after the cursor, so once your query/batch gets big it isn't seeing enough to give suggestions.

If you contact support they can give you instructions on adjusting how many characters it looks at, but I have found if I set them large enough to work that SQL Prompt gets too slow and it is worse than not getting suggestions at all.

jreynolds

I have opened a ticket to see if I can learn the secret sauce.

Thanks.

Anu D

Hello,

If you experience issues with SQL Prompt not suggesting variables over large blocks of SQL or SQL Prompt is failing to provide help when you have a large script, please do email support@red-gate.com for a workaround.