Activity overview
Latest activity by michaelfried
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
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...
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
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.
...
Sent an email to RedGate Support as requested.
Mike / comments
Sent an email to RedGate Support as requested.
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...
Aliases in Brackets
Is there a way to turn off Aliases in SELECTs and JOINs from automatically having Brackets around them when SQL Prompt auto-inserts the subclause?
For Example:SELECT *
FROM [dbo].[My...
Line Return Indentation Issue
As I am typing in a query, I have not figured out how to get the new line indentation to start at the level of indentation of the previous line in SQL Prompt 4.
For Example:SELECT a.[Column1	...
MasterCephus wrote:
If that's right (which I am not doubting you, just talking out loud), then there is no way to naturally delete the local files that you create...so the FILEOPTIONS flag is meaningless without doing something manually...
I agree. I don't think that should be the proper behavior for the ERASEFILES Option. It should be left up to the User on how to keep/erase/backup etc the backup files according to their needs and/or requirements.
I just use a separate scheduled batch file job to delete the local files. Not the best option, but it works! Hopefully, RedGate will look into changing this functionality in future versions of the SQL Backup product.
Mike / comments
MasterCephus wrote:
If that's right (which I am not doubting you, just talking out loud), then there is no way to naturally delete the local files that you create...so the FILEOPTIONS flag is me...