June 21, 2010 at 1:11 pm
Hi,
Any suggestions or feedback would greatly appreciated.
I'm writing SQL query in SSMS and I'd like to avoid using a specific table.
For example:
SELECT * FROM SALARY
however, I'm very forgetful so I need a way to parse my query to do find and replace before execution:
SELECT * FROM V_SALARY
is there an add-on for this?
thanks!
June 21, 2010 at 1:29 pm
I don't know about an add-in but in the editor window you can select edit from the menu and select find/replace. ssms contains the functionality to do a search and replace without any additional add ons
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 21, 2010 at 1:41 pm
it would be nice if while I'm writing a query, it would highlight the words if the condition hits (as a warning), or even better, do find-and-replace before query execution.
June 21, 2010 at 1:46 pm
I see what you are asking for now. there are several high end SQL editors you can buy with much more advanced coding options but personally I hope they never write an editor that intelegent. If they do then there will be no real need to have skills that warrant a higher pay.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 21, 2010 at 2:30 pm
The only thing I know of in SSMS that would come close to what you are looking for is templates. You can create a template with placeholders for your objects, hit the fill in template button and be prompted for all of the variables.
Once that is done, you can execute the code. Just remember, don't ever save over your template or you will be rebuilding it.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply