+ Reply to Thread
Results 1 to 6 of 6

Thread: SQL2000Analyzer equivalent in 2005?

  1. #1
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    SQL2000Analyzer equivalent in 2005?

    Hi All,

    1) Where is the analyzer tool in 2005?

    2) If you have 2 queries in window but only highlight 1, will it just execute that one like in sqlAnalyzer?

    Thankies!

  2. #2
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    found it..."New Query" on the database name level.

    i don't like changes.....i hope i don't have to upgrade yet.

  3. #3
    Wolfmaster Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy's Avatar
    Join Date
    Mar 2008
    Location
    Peoria, IL
    Posts
    2,386
    Blog Entries
    5
    Real Name
    Wolff
    Rep Power
    15

    Yup, in Query Manager in 2005 you can swipe the commands and press F5 to execute the highlighted bits.
    Wolffy
    .-- ----- ..-. ..-. -.--
    Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.

  4. #4
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Thanks W0lffy,

    Another question, I see the icon to for design view but when I click it, it opens a new window, does this always happen this way to use the design view?

  5. #5
    Wolfmaster Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy is a splendid one to behold Wolffy's Avatar
    Join Date
    Mar 2008
    Location
    Peoria, IL
    Posts
    2,386
    Blog Entries
    5
    Real Name
    Wolff
    Rep Power
    15

    Huh? I don't have any icons, let alone anything about Design View. What tool are we talking about? Management Studio?
    Wolffy
    .-- ----- ..-. ..-. -.--
    Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.

  6. #6
    Barn Legend Rebelle will become famous soon enough Rebelle's Avatar
    Join Date
    Mar 2008
    Posts
    1,522
    Rep Power
    5

    Quote Originally Posted by Wolffy View Post
    Huh? I don't have any icons, let alone anything about Design View. What tool are we talking about? Management Studio?
    Yes, in the Management Studio...when you click on "New Query" you get a new tool bar at the top...you can see the !Execute button and about 5 icons down one is called Design in Query Editor.

+ Reply to Thread

Similar Threads

  1. Equivalent of Limit in MySql
    By micky in forum Microsoft SQL Server
    Replies: 6
    Last Post: July 24th, 2009, 06:29 AM
  2. Pivot with out Aggregate Function -SQL 2005
    By MySQL in forum Microsoft SQL Server
    Replies: 6
    Last Post: July 21st, 2009, 10:50 AM
  3. Replies: 3
    Last Post: July 21st, 2009, 12:36 AM
  4. PHP equivalent to MySQL IN statement?
    By bryceowen in forum PHP Development
    Replies: 2
    Last Post: July 8th, 2009, 04:01 PM
  5. UBound and LBound equivalent for PHP?
    By bryceowen in forum PHP Development
    Replies: 1
    Last Post: September 12th, 2008, 10:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO