Post reply

Stored Proc -- Temp Table Scripting, etc

  • August 11, 2004 at 7:01 pm

    #108578

    What GUI interface to do you recommend

    for creating StoredProcs? Currently we do the

    query in EnterpriseManager GUI, copy code into

    a StoredProc, and then run. We are using Query

    Analyzer to create "temp table" code, etc

    and think their might be a better way.

  • August 13, 2004 at 2:18 am

    #518816

    From the Query analyser, you can try using templates.

    I hope it will be more meaningful than the wizard from Sql Enterprise Manager.

    Thanks,

    Ganesh

  • August 13, 2004 at 8:02 am

    #518889

    Take the time to learn to do this through QA.

    Also, you don't say if the temp table code is for an application, but if so create the temp tables in the business objects against the connection, and then populate the tables in the stored procedures.

    Don't mix the two in the same stored procedures, unless it's for some ad hoc items that you run against the analyzer.

Viewing 3 posts - 1 through 2 (of 2 total)

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