Comments
Sort by recent activity
Hi
I too have both installed but keep a separate set of options
For example , in Refactor I have column on a new line disabled , in SQLPrompt I have the opposite
That way I can keep code compact while I'm working on it and then change the layout to "final" columns on new lines when I'm done
I find having the 2 quite useful on occasions
Mike / comments
Hi
I too have both installed but keep a separate set of options
For example , in Refactor I have column on a new line disabled , in SQLPrompt I have the opposite
That way I can keep code compact w...
I haven't actually seen SQL 2008 yet , I must have a look , it would be an excellent addition.
When I bought my Visual Studio 2008 , they hadn't launched SQL 2008 or no doubt they would include the developer edition in there
Cheers
Mike / comments
I haven't actually seen SQL 2008 yet , I must have a look , it would be an excellent addition.
When I bought my Visual Studio 2008 , they hadn't launched SQL 2008 or no doubt they would include the...
Surely if you goto Cache management you get 2 offers , Refresh All or highlight a single Db and click Refresh , it does just the one selected
Also theres a check box for Refresh the Cache when opening a new Queyy editor instance, but I suspct that could be a lengthy one .
I normally use the single db Refresh when I am working a Db thats changing a lot
Mike / comments
Surely if you goto Cache management you get 2 offers , Refresh All or highlight a single Db and click Refresh , it does just the one selected
Also theres a check box for Refresh the Cache when open...
No Problem now Thanks / comments
No Problem now Thanks
Maybe an idea is a "Code Gallery" for snippets somewhere on the site
I know I have created a fair number of personalised ones as I'm sure many people have.
"Share and Enjoy" --- HHG sded =
DECLARE @StartDate DateTime
DECLARE @EndDate DateTime
Set @StartDate = DateAdd(d,-1,GETDATE())
Set @EndDate = GETDATE()
/ comments
Maybe an idea is a "Code Gallery" for snippets somewhere on the site
I know I have created a fair number of personalised ones as I'm sure many people have.
"Share and Enjoy" --- HHGsded =
DECLARE...
Hi Tanya
I can be a bit vague !!
I use the facility of hovering over a name to see the script of the SP , if I have a line that is EXEC spName , I use the hover to get the script , copy it and paste it to a new window so that I can see whats going one in the called SP.
If the called SP has been changed since the last Cache Refresh , its shows me the OLD version , If I refresh the Cache I see the NEW one.
I think you've answered it ,if any changes are made they only reflect after a manual update or Cache refresh.
It would be nice , that if the schema of a SP is copied to clipboard , that it be the live one , not the Cached one .
Using the hyperlink to get the text of an SP is nice feature ,just in this instance , a bit confusing.
Cheers
Mike / comments
Hi Tanya
I can be a bit vague !!
I use the facility of hovering over a name to see the script of the SP , if I have a line that is EXEC spName , I use the hover to get the script , copy it and past...
Hi
I have managed to activate the product by doing exactly as you said , but its not a simple method , I literally had to ban my wife from logging onto our PC in her name while I left the activation wizard open for 8 hrs plus, which you can imageine pleased her a lot !!
I appreciate the need to verify legitimate license holders but its not very convenient for the "customer".
That said I should be fine til I buy a new PC
Justa thought for future issues maybe
Cheers
Mike / comments
Hi
I have managed to activate the product by doing exactly as you said , but its not a simple method , I literally had to ban my wife from logging onto our PC in her name while I left the activatio...
Seems only to happen if the String is outside of a sql statement
Open a new query window type 'Measurement Type' and you get caps TYPE
now type
SELECT * FROM BBT WHERE BBTCode ='Meaurement Type' and you get lower case
Type simply Meaurement Type again and still lower case.
I can only make it happen when its the first line of a clean window so far. / comments
Seems only to happen if the String is outside of a sql statement
Open a new query window type 'Measurement Type' and you get caps TYPE
now type
SELECT * FROM BBT WHERE BBTCode ='Meaurement Type' an...
"Don't miss me " [image] , my intial reactions are in the main forum
But seriously , I will get back with more as I continue working with it, as I said above , I am well pleased with the improvements I have spotted so far .
Is there a "list" of enhancements , fixes etc that I have missed, I would hate to not see something
Cheers
Mike / comments
"Don't miss me " , my intial reactions are in the main forum
But seriously , I will get back with more as I continue working with it, as I said above , I am well pleased with the improvements I ha...
Hi
Without "punting" another Red Gate Product ( which I will !!) have you looked at SQL Refactor , which you can configure very flexibly to position columns all in one line , or new line etc , pre comma's post comma's , and loads more
Its a nice tool to "Order the Mess" of a lot of stored procs I have seen ..
Even some of my own
"Write scruffy , tidy up once your'e done" -- probbaly not quite best practice but >>>
Mike / comments
Hi
Without "punting" another Red Gate Product ( which I will !!) have you looked at SQL Refactor , which you can configure very flexibly to position columns all in one line , or new line etc , pre ...