Post reply

Helping hand for beginner

  • May 13, 2007 at 1:28 pm

    #176356

    Hi all,

     

    Folks I am a SQL DBA much familiar GUI, but now I want to deal every thing with T-SQL and the irony is I am an illiterate in this regard is there any free tool available which helps me creating SPs and other queries.

     

    Thanks in advance  

  • May 13, 2007 at 2:29 pm

    #706066

    Query Analyzer.

    Plenty of options available in "New" submenu.

    And right-clicks on objects in Object Browser (press F8 to open it) will help you to build scripts you need.

    _____________
    Code for TallyGenerator

  • May 13, 2007 at 3:09 pm

    #706068

    thanks....

     

  • May 14, 2007 at 3:42 am

    #706155

    And don't forget Books Online

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 15, 2007 at 10:57 am

    #706582

    There is also a "Create Stored Procedure" Wizard available from Enterprise Manager under Tools - Wizards - Database. I've never used them but you could try it out.

    Steve

  • May 15, 2007 at 2:59 pm

    #706613

    You might also try messing around in EM's GUI, graphically querying tables, and see what T-SQL is created.  That helped me quite a lot whan I was getting started.

  • May 15, 2007 at 5:20 pm

    #706629

    And once you've worked with the BOL and want to advance even more, check out Ken Henderson's Guru's Guide to Transact SQL.

    -SQLBill

  • May 17, 2007 at 1:16 am

    #707023

    You could try the SSCodeGen software at http://www.downloaddatabase.com/databasedevelopment/sscodegen.htm

  • May 18, 2007 at 12:21 am

    #707321

    Thanks one and all

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply