What are the challenges you face when working across database platforms? Take the survey

Not recognizing variables until new line

Matthew.WilkersonMatthew.Wilkerson Posts: 45
edited March 25, 2009 5:00PM in SQL Prompt Previous Versions
We create our variables like this, initializing them on the same line:

DECLARE @this_is_a_variable_with_a_long_name int; SET @this_is_a_variable_with_a_long_name = 0

Is there any way to have SQL Prompt recognize the variable name after the semicolon is typed so that we can use it in the set statement? Otherwise we have to either retype the variable name or cut and paste it. Thanks.


  • Options
    Hi Matthew,

    Unfortunately there isn't an option to make this work when you are setting the variable on the same line.

    I have added this as a bug/feature request which will be considered for a future release.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.