Results 1 to 4 of 4

Thread: Testing SQL Statements

  1. #1
    chatterbox's Avatar
    chatterbox is offline Newbie Net Builder
    Join Date
    Jul 2009
    Location
    Australia
    Posts
    141
    Thanks
    15
    Thanked 12 Times in 10 Posts

    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
    moonshaneisle is offline Newbie Net Builder
    Join Date
    Jul 2009
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

  3. #3
    ahmedgg is offline Newbie Net Builder
    Join Date
    Jul 2009
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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
    johnting101 is offline Newbie Net Builder
    Join Date
    Jun 2009
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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, 07: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

Bookmarks

Posting Permissions

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