Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Command in sql 2000 to comment multiple lines

Author  Topic 

gamaz
Posting Yak Master

104 Posts

Posted - 2010-05-06 : 18:26:31
Hi,
I am looking for ways to comment few lines with one command issue. This is not the same as /* */.
I appreciate any help. Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-06 : 18:43:44
In Query Analyzer, you can use CTRL+SHIFT+C to comment a block quickly.

If that's not what you are looking for, then you need to be more clear.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

gamaz
Posting Yak Master

104 Posts

Posted - 2010-05-07 : 12:19:04
Thanks Tara for the help. That is what exactly I was looking for.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-07 : 12:52:38
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-05-07 : 15:29:19
... and then CTRL+SHIFT+R to remove them
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-07 : 16:02:38
Test

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-05-10 : 04:02:53
This is changed from version 2005 onwards

CTRL+K, CTRL+C for comment
CTRL+K, CTRL+U for Uncomment


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-05-10 : 07:16:46
Far less useful/usable IMHO
Go to Top of Page
   

- Advertisement -