Results 1 to 4 of 4

Thread: Testing SQL Statements

  1. #1

    Testing SQL Statements

    Im working with a SQL Server that i have limited access to. Is there a program (freeware preferred) that i can use to run my DDL against to verify it will process correctly when run on the SQL Server? Thanks.
    Sound Unsound is a music forum for Unsigned Artists, Dj's and Producers
    Others: PDA and Smartphone guide | What task will you do for cheap? | Crazy Links 4 Free

  2. #2

  3. #3
    Run the query in a transaction, and then roll it back.

    Or, a much weaker method, ask for an estimated query plan. This will only verify syntax and that it can be compiled against a schema, not that the code is valid for the data itself (that the script will run without error).

  4. #4
    thanks for the info.

Similar Threads

  1. PHP Programming question regarding if statements?
    By closebys in forum Programming
    Replies: 3
    Last Post: 12 March, 2010, 08:12 AM
  2. [Announcement] Testing New Ads!
    By Will.Spencer in forum Announcements and Suggestions
    Replies: 18
    Last Post: 16 October, 2009, 13:19 PM
  3. Jokes and funny statements
    By mega in forum General Chat
    Replies: 5
    Last Post: 16 May, 2009, 13:47 PM

Tags for this Thread


Posting Permissions

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