Max. length for input parameter

[Tinti]

Hello

in a command window I try to start a sql script like following:

@'C:\TEMP\test.sql' '&stmt'

The &stmt prompt me for an input. In my case this input can be a large query. Unfortunately the prompt seems to access only 50 character. Is it possible to increase this size?

Thank's for any help
Joerg

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Tinti]

Thank you!

 

[Marco Kalter]

I just tried to reproduce this, but I can get more that 50 characters. In fact, I don't think there is a limit.

 

[Worker]

The input field appears to be limited to 255 characters. But I agree, all 255 seem to make it into the script as a parameter just fine.

 

[Tinti]

The limit is in fact 255 and not 50 characters. Sorry.

But if I start the query in a sql window I will prompted for an input parameter and there I can paste a large query (incl. line breaks). If I start the query from a command window and paste the same query in the prompt then the parameter has the value until the first line break. Informations after the first line break will be ignored.

My solution will be that I have to run the script in a sql window.

Thanks for your support