|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Copy/Paste behavior in SSMSI realize that this seems odd, but I want to change the copy paste
behavior in SSMS. Right now if you have no text selected in SSMS and do a control-c the entire line is copied, but I want the copy to be null. Basicly I'm automating some repetive functions and need to move only the selected text to the clipboard. If no text is selected then want nothing. Any ideas? Thanks William wgbrown_nospam_@gmail.com How are you automating the tasks?
Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ <wgbr***@gmail.com> wrote in message Show quote news:1164146398.788232.175850@k70g2000cwa.googlegroups.com... >I realize that this seems odd, but I want to change the copy paste > behavior in SSMS. > > Right now if you have no text selected in SSMS and do a control-c the > entire line is copied, but I want the copy to be null. Basicly I'm > automating some repetive functions and need to move only the selected > text to the clipboard. If no text is selected then want nothing. > > Any ideas? > > Thanks > > William > wgbrown_nospam_@gmail.com > Using Autohotkey - www.autohotkey.com. Its a scripting language to
automate tasks. Right now I've had problems pulling selected text using its tools - some editors don't get along with it so I've resorted to using the clipboard but the SSMS behavior is different that other tools. Thanks William Paul A. Mestemaker II [MSFT] wrote: Show quote > How are you automating the tasks? > > Paul A. Mestemaker II > Program Manager > Microsoft SQL Server Manageability > http://blogs.msdn.com/sqlrem/ > > <wgbr***@gmail.com> wrote in message > news:1164146398.788232.175850@k70g2000cwa.googlegroups.com... > >I realize that this seems odd, but I want to change the copy paste > > behavior in SSMS. > > > > Right now if you have no text selected in SSMS and do a control-c the > > entire line is copied, but I want the copy to be null. Basicly I'm > > automating some repetive functions and need to move only the selected > > text to the clipboard. If no text is selected then want nothing. > > > > Any ideas? > > > > Thanks > > > > William > > wgbrown_nospam_@gmail.com > > I'm not famliar with this utility at all. Can you give us an example of the
task you'd like to automate? Maybe we can find you a way to complete your task using SQLCMD Mode in SSMS. -Paul <wgbr***@gmail.com> wrote in message Show quote news:1164179204.938292.85990@k70g2000cwa.googlegroups.com... > Using Autohotkey - www.autohotkey.com. Its a scripting language to > automate tasks. Right now I've had problems pulling selected text > using its tools - some editors don't get along with it so I've resorted > to using the clipboard but the SSMS behavior is different that other > tools. > > Thanks > > William > > > Paul A. Mestemaker II [MSFT] wrote: >> How are you automating the tasks? >> >> Paul A. Mestemaker II >> Program Manager >> Microsoft SQL Server Manageability >> http://blogs.msdn.com/sqlrem/ >> >> <wgbr***@gmail.com> wrote in message >> news:1164146398.788232.175850@k70g2000cwa.googlegroups.com... >> >I realize that this seems odd, but I want to change the copy paste >> > behavior in SSMS. >> > >> > Right now if you have no text selected in SSMS and do a control-c the >> > entire line is copied, but I want the copy to be null. Basicly I'm >> > automating some repetive functions and need to move only the selected >> > text to the clipboard. If no text is selected then want nothing. >> > >> > Any ideas? >> > >> > Thanks >> > >> > William >> > wgbrown_nospam_@gmail.com >> > > Good Morning Paul.
There isn't one function but a bunch of little ones. Currently I'm closing off certain characters like { [ ( " so I get {}, [], (), "" (I work a lot in mdx). But I'd like to be able to reformat highlighted text. Proper case words or such. I was surprised about the copy behavior - I'd never noticed it. Thanks William Paul A. Mestemaker II [MSFT] wrote: Show quote > I'm not famliar with this utility at all. Can you give us an example of the > task you'd like to automate? Maybe we can find you a way to complete your > task using SQLCMD Mode in SSMS. > > -Paul > > <wgbr***@gmail.com> wrote in message > news:1164179204.938292.85990@k70g2000cwa.googlegroups.com... > > Using Autohotkey - www.autohotkey.com. Its a scripting language to > > automate tasks. Right now I've had problems pulling selected text > > using its tools - some editors don't get along with it so I've resorted > > to using the clipboard but the SSMS behavior is different that other > > tools. > > > > Thanks > > > > William > > > > > > Paul A. Mestemaker II [MSFT] wrote: > >> How are you automating the tasks? > >> > >> Paul A. Mestemaker II > >> Program Manager > >> Microsoft SQL Server Manageability > >> http://blogs.msdn.com/sqlrem/ > >> > >> <wgbr***@gmail.com> wrote in message > >> news:1164146398.788232.175850@k70g2000cwa.googlegroups.com... > >> >I realize that this seems odd, but I want to change the copy paste > >> > behavior in SSMS. > >> > > >> > Right now if you have no text selected in SSMS and do a control-c the > >> > entire line is copied, but I want the copy to be null. Basicly I'm > >> > automating some repetive functions and need to move only the selected > >> > text to the clipboard. If no text is selected then want nothing. > >> > > >> > Any ideas? > >> > > >> > Thanks > >> > > >> > William > >> > wgbrown_nospam_@gmail.com > >> > > > See if this helps with what you want?
http://www.red-gate.com/products/SQL_Refactor/index.htm -- Show quoteAndrew J. Kelly SQL MVP <wgbr***@gmail.com> wrote in message news:1164215484.851461.150040@h54g2000cwb.googlegroups.com... > Good Morning Paul. > > There isn't one function but a bunch of little ones. Currently I'm > closing off certain characters like { [ ( " so I get {}, [], (), "" (I > work a lot in mdx). But I'd like to be able to reformat highlighted > text. Proper case words or such. > > I was surprised about the copy behavior - I'd never noticed it. > Thanks > > William > > > Paul A. Mestemaker II [MSFT] wrote: >> I'm not famliar with this utility at all. Can you give us an example of >> the >> task you'd like to automate? Maybe we can find you a way to complete >> your >> task using SQLCMD Mode in SSMS. >> >> -Paul >> >> <wgbr***@gmail.com> wrote in message >> news:1164179204.938292.85990@k70g2000cwa.googlegroups.com... >> > Using Autohotkey - www.autohotkey.com. Its a scripting language to >> > automate tasks. Right now I've had problems pulling selected text >> > using its tools - some editors don't get along with it so I've resorted >> > to using the clipboard but the SSMS behavior is different that other >> > tools. >> > >> > Thanks >> > >> > William >> > >> > >> > Paul A. Mestemaker II [MSFT] wrote: >> >> How are you automating the tasks? >> >> >> >> Paul A. Mestemaker II >> >> Program Manager >> >> Microsoft SQL Server Manageability >> >> http://blogs.msdn.com/sqlrem/ >> >> >> >> <wgbr***@gmail.com> wrote in message >> >> news:1164146398.788232.175850@k70g2000cwa.googlegroups.com... >> >> >I realize that this seems odd, but I want to change the copy paste >> >> > behavior in SSMS. >> >> > >> >> > Right now if you have no text selected in SSMS and do a control-c >> >> > the >> >> > entire line is copied, but I want the copy to be null. Basicly I'm >> >> > automating some repetive functions and need to move only the >> >> > selected >> >> > text to the clipboard. If no text is selected then want nothing. >> >> > >> >> > Any ideas? >> >> > >> >> > Thanks >> >> > >> >> > William >> >> > wgbrown_nospam_@gmail.com >> >> > >> > > I've looked at that and it looks really nice. As soon as I have time I
want to try it out. Much of my work is around MDX however, and the tools are more limited. For good reason, for every person who does MDX there must be 1000 (or more) sql programmers. Thanks for the tip. William Andrew J. Kelly wrote: Show quote > See if this helps with what you want? > > http://www.red-gate.com/products/SQL_Refactor/index.htm > > -- > Andrew J. Kelly SQL MVP > > <wgbr***@gmail.com> wrote in message > news:1164215484.851461.150040@h54g2000cwb.googlegroups.com... > > Good Morning Paul. > > > > There isn't one function but a bunch of little ones. Currently I'm > > closing off certain characters like { [ ( " so I get {}, [], (), "" (I > > work a lot in mdx). But I'd like to be able to reformat highlighted > > text. Proper case words or such. > > > > I was surprised about the copy behavior - I'd never noticed it. > > Thanks > > > > William > > > > > > Paul A. Mestemaker II [MSFT] wrote: > >> I'm not famliar with this utility at all. Can you give us an example of > >> the > >> task you'd like to automate? Maybe we can find you a way to complete > >> your > >> task using SQLCMD Mode in SSMS. > >> > >> -Paul > >> > >> <wgbr***@gmail.com> wrote in message > >> news:1164179204.938292.85990@k70g2000cwa.googlegroups.com... > >> > Using Autohotkey - www.autohotkey.com. Its a scripting language to > >> > automate tasks. Right now I've had problems pulling selected text > >> > using its tools - some editors don't get along with it so I've resorted > >> > to using the clipboard but the SSMS behavior is different that other > >> > tools. > >> > > >> > Thanks > >> > > >> > William > >> > > >> > > >> > Paul A. Mestemaker II [MSFT] wrote: > >> >> How are you automating the tasks? > >> >> > >> >> Paul A. Mestemaker II > >> >> Program Manager > >> >> Microsoft SQL Server Manageability > >> >> http://blogs.msdn.com/sqlrem/ > >> >> > >> >> <wgbr***@gmail.com> wrote in message > >> >> news:1164146398.788232.175850@k70g2000cwa.googlegroups.com... > >> >> >I realize that this seems odd, but I want to change the copy paste > >> >> > behavior in SSMS. > >> >> > > >> >> > Right now if you have no text selected in SSMS and do a control-c > >> >> > the > >> >> > entire line is copied, but I want the copy to be null. Basicly I'm > >> >> > automating some repetive functions and need to move only the > >> >> > selected > >> >> > text to the clipboard. If no text is selected then want nothing. > >> >> > > >> >> > Any ideas? > >> >> > > >> >> > Thanks > >> >> > > >> >> > William > >> >> > wgbrown_nospam_@gmail.com > >> >> > > >> > > >  |
|||||||||||||||||||||||
Other interesting topics