Comments
Sort by recent activity
A Stored Procedure cannot begin a new line (or current line) after another statement (within a single batch) without using the EXEC keyword.
If you type in: SELECT * FROM myTable
EXEC ap_
you should get all the suggestions that match your input.
Mike / comments
A Stored Procedure cannot begin a new line (or current line) after another statement (within a single batch) without using the EXEC keyword.
If you type in:SELECT * FROM myTable
EXEC ap_
you shou...
Yes, you are correct, it does happen with Temp Tables and Table Variables.
Mike / comments
Yes, you are correct, it does happen with Temp Tables and Table Variables.
Mike
Tim,
I don't see that happening with SELECT * or INSERT INTO auto completion. Both types of auto-complete list all the columns in their natural table order.
I also don't see a setting to change that behavior either.
Mike / comments
Tim,
I don't see that happening with SELECT * or INSERT INTO auto completion. Both types of auto-complete list all the columns in their natural table order.
I also don't see a setting to change th...
The SQL Prompt 4 detailed version is 4.0.2.27.
SQL Server Management Studio Version is 9.00.3042.00.
Enter the following query in the msdb database in SSMS and then use the Tab key to expand the SELECT statement: SELECT sai.*
FROM [dbo].[sqlagent_info] sai
It used to (and should in my opinion) display as follows: SELECT sai.[attribute],
sai.[value]
FROM [dbo].[sqlagent_info] sai
but instead appears with brackets around the aliases: SELECT [sai].[attribute],
[sai].[value]
FROM [dbo].[sqlagent_info] sai
Mike / comments
The SQL Prompt 4 detailed version is 4.0.2.27.
SQL Server Management Studio Version is 9.00.3042.00.
Enter the following query in the msdb database in SSMS and then use the Tab key to expand the SE...
I tried your suggstion and it made no difference. The option was already unchecked. I tried both ways (checked and unchecked) and it still does not indent properly.
Mike / comments
I tried your suggstion and it made no difference. The option was already unchecked. I tried both ways (checked and unchecked) and it still does not indent properly.
Mike
Sent an email to RedGate Support as requested.
Mike / comments
Sent an email to RedGate Support as requested.
Mike
Despite the other posts regarding issues and functionality changes (or bugs) posted by myself and others, I think we all have noticed the speed/performance increase and the improved response time.
Thanks for these improvements!
Once we are able to work through a lot of these little issues (hopefully fairly quickly), I am sure this will become one of the best RedGate tools that help all of us database coders complete our work faster and more accurately! I know I use it constantly every day, all day long!
Mike / comments
Despite the other posts regarding issues and functionality changes (or bugs) posted by myself and others, I think we all have noticed the speed/performance increase and the improved response time.
...