Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to bypass lines in query window?
Message
De
10/08/2011 17:26:16
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01520522
Message ID:
01520627
Vues:
44
>>One handy use for that is if you have half a dozen queries you run regularly to test something. You can throw them all in one sql and then bring that up to run portions when you want, kind of like we do with the VFP comman window, running blocks of code from history.
>>
>>Less cumbersome than storing each query off in its own sql file.
>
>BTW, here is another neat trick
>
>http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/sql-query-commenting-uncommenting-quick

Thanks, that is cool. I also like the idea that you can -- out lines in the middle of queries, so you can have multiple WHERE statements and just take out -- for the one you want to try.


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform