Post reply

Writing Stored Procedures Without Knowing T-SQL

  • November 21, 2006 at 11:22 pm

    #175464

    Is it possible to write stored procedures without knowing T-SQL? Thanks!

    Kindest Regards,

    Jonathan C

    http://www.sqltraceanalyzer.com/

    SQL Trace Analyzer - Performance Tuning Tool - Free 30-day trial download.

  • November 22, 2006 at 3:42 am

    #673406

    Hi,

    You can, if you think that you can drive without knowing it.

    Cheers

    cheers

  • November 22, 2006 at 5:15 am

    #673416

    get somebody to do it for you and claim the fame.

    you would probably need to just know a bit and then use a wizard to create the code for you.

    Everything you can imagine is real.

  • November 22, 2006 at 8:01 am

    #673467

    just copy and past from the script archive here

  • November 22, 2006 at 8:05 am

    #673468

    books online will help you with anything you need, and this site when you get stuck. if you know basic sql, then your half way there. im no genius, but i can write most sprocs that i ever will have a use for, and if i need something i am unsure of how to accomplish, this site, or the MSDN forums, or BOL always help

  • November 27, 2006 at 9:03 am

    #674093

    In google do the following and you'll see that a stored procedure is a collection of SQL statements. If someone gave you one or more SQL statements you could write a SP with them, once you learned the simple syntax of the CREATE.

    define: stored procedure

  • November 28, 2006 at 2:05 pm

    #674531

    Yep, as said above really, this would more than pay off the investment of a few hours of your time, and tSQL's really not that hard. You can also find loads of useful script fragments just by googling or searching on here. Many times the google search results will take you back to this site in any case.

    Best of luck with it.

    Bart

Viewing 7 posts - 1 through 6 (of 6 total)

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