Re: Any good, free tools for writing simple stored procedures?

I use SQL Server Query Analyzer most of the time. OK it lacks intellisense
but it does have a debugger, object browser, scripting, graphical query
plans, templates, and probably a lot of other things I've forgotten. It will
save you some typing too because you can drag column lists and table names
from the object browser into the editing window.

For code generation of standard procs I write my own scripts (using QA).

If you've already decided you don't like QA, some other tools are listed
here:
http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--


.

Relevant Pages

  • Re: sql server stored procedure
    ... the necessary directory. ... Because this sql server query is already in place & been thoroughly ... archived data no matter what you do in Access. ...
    (microsoft.public.access.externaldata)
  • Re: How to Create Local Temporary Table
    ... I have worked with both Oracle and SQL Server for some time and have grown to appreciate how much more mature Oracle is than SQL Server. ... When most think of scripting in Windows, they think of DOS command line scripting. ...
    (comp.databases.oracle.server)
  • Re: Sql Management Studio - Script Db creates objects out of ourder
    ... Scripting depends on the dependency information in the database. ... flexible nature of SQL Server, ... and the a stored procedure kalle_sp that refers ... to nissetbl, SQL Server with store information about this. ...
    (microsoft.public.sqlserver.tools)
  • Re: Scripting Performance after SP2 applied?
    ... I agree that there is a lot of time spent setting up the scripting in the ... As far as memory configuration, I have always set my max server memory set ... now with forced parameterization, ... I then restarted SQL Server, and set the database to forced ...
    (microsoft.public.sqlserver.tools)
  • Re: SMSS SP2 Script Database objects error
    ... Determining objects in database 'NameHost' that will be scripted. ... query using ANSI outer join operators (LEFT OUTER JOIN, ... In the future versions of SQL Server, ... scripting, I find it difficult to believe that it would be that bad. ...
    (microsoft.public.sqlserver.tools)